Hi All,
I am currently in the process of streamlining some VBA code which I obtained via record macro and was wondering if I someone would be able to point me in the right direction.
I want to select cells from B6:B150 then copy and paste to another location. This process is repeated for over 20 columns (e.g. D6:E150, F6:F150 etc).
As the there are gaps inbetween rows 6 -150 (for formatting), I have this clumsy code which repeats the below multiple times until it gets to row 150:
Range(Selection, Selection.End(xlDown)).Select
Is there a easier way of selecting these rows?
Thanks for your help.
Bookmarks