Forum Discussion
Lulu4466660
Nov 06, 2019Copper Contributor
Specifically select column 3 to 156 and line 2 to 179 automatically from a database
I want specifically select column 3 to 156 and line 4 to 179 automatically from a database. How to do it?
Chris Newman
Nov 06, 2019MVP
You can create a little macro to do this (assumes your data starts in cell A1):
Sub SelectMyRange()
Range("C2:EZ179").Select
End Sub
You can throw this macro into your Personal Macro workbook and run it on demand whenever you'd like.
- Lulu4466660Nov 07, 2019Copper ContributorThank you for your answer. I will test it!