In VBA how do I enhance this line in a macro to use the contents of cell A1 as the end of the range?
Current:
Rows("2:200").Select
Desired:
Rows("2:A1").Select
I have guessed at various syntax and cannot get it to work.
Thanks very much.