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.
Lulu4466660
Nov 07, 2019Copper Contributor
Thank you for your answer. I will test it!