If the Rows increase first you need to find your last row therefo

iLastRow = Range("C65536").end(xlup).row
Then you will need something like this

Range("A1:C" & iLastRow).select


--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Simon - M&M" wrote:

Hi there,

I'm writing a macro at the moment to select for example cells A:1 to C:5,
this i can do, however this range of data increases. Today it might be A:1 to
C:5 and tomorrow it might be A1 to C6. I'm having minimal success with this.
Can someone please tell me how i can achieve it?
Many thanks in advance

Simon