Selecting certain rows

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:

Please Login or Register  to view this content.

Is there a easier way of selecting these rows?
Thanks for your help.

Hi,

You can use,

Please Login or Register  to view this content.

or, u can use. this will select the cells from B6 until it finds the nonblank cell in the sheet.

Please Login or Register  to view this content.

Hi,

One way

Name the cell location in which you want to paste the results as 'myrange' then run the following macro

Please Login or Register  to view this content.

...and if I misinterpreted the original perhaps. Create the range name myrange as before

Please Login or Register  to view this content.