macro selecting data in a row with empty cells

[already]

Hi,

I have to select and cut a column with on several lines empty cells.
I use the following code 'Range("c2", Range("c2").End(xlDown)).Cut' but this code select only the data till the first empty cell.
How can I select the whole column till the last cell. The column B is filled with data on every row so I think that I have to use
the offset code.

Thanks in advance for your help.

Kind regards

Al

 

[Andrew Poulsom]

Try:

Range("C2", Range("C" & Rows.Count).End(xlUp)).Cut

 

[already]

Hi Andrew,

Thanks for this code it works fine!

Kind regards

Al