VBA to select all cells with content
 

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

VBA to select all cells with content
 

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

VBA to select all cells with content
 

In article , Bob Phillips
writes
Try

Range("A1").CurrentRegion.Select


HI

Yes , that's perfect - thanks!