Prev: Cell Formats - Limit # of characters
Next: why can't i browse to a location to save a flat file
From: Colin Hayes on 1 Apr 2010 18:18

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
From: Bob Phillips on 1 Apr 2010 18:27
Try

Range("A1").CurrentRegion.Select

--

HTH

Bob

"Colin Hayes" <Colin(a)chayes.demon.co.uk> wrote in message
news:LSmplIAFvRtLFwPL(a)chayes.demon.co.uk...
>
> 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


From: Colin Hayes on 1 Apr 2010 19:08
In article <uD0EEqe0KHA.4420(a)TK2MSFTNGP02.phx.gbl>, Bob Phillips
<bob.phillips(a)somewhere.com> writes
>Try
>
>Range("A1").CurrentRegion.Select
>

HI

Yes , that's perfect - thanks!
 | 
Pages: 1
Prev: Cell Formats - Limit # of characters
Next: why can't i browse to a location to save a flat file