Select Cells macro

[TimmerSuds]

I have a spreadsheet that has 9 columns and a varying amount of rows.

I need to create a macro that selects all 9 columns for every row in which column #2 has data.

Appreciate any help.

Thanks

[Richard Buttrey]

Hi,

...and then what do you want to do. As a general principle you should avoid selecting cells/ranges unless you only want to position the cursor.

If for instance you want to copy them then this is one way - assumes your data starts in A1

Please Login or Register  to view this content.

[TimmerSuds]

This works - almost...

I need the range to copy to begin with cell A2 and not A1.

I made the following changes but it doesn't work correctly..

Please Login or Register  to view this content.

What am I overlooking?

Thanks