Try

Range("A1").CurrentRegion.Select

--

HTH

Bob

"Colin Hayes" wrote in message
...

Hi

I need some advice with some VBA coding.

I need to select all the cells in my worksheet which have content.

Effectively selecting from A1 to the last cell in the last row , whichever
it happens to be..

Can someone help with this?

Thanks