Andy,
Try UsedRange it returns A1 to the bottom right of the
active sheet

Trev
-----Original Message-----
Simple answer im sure but it is Friday!!!!

Hi,

Im trying to select a range.

i.e Range("A1:A23456").select

however, the last cell will change as the range grows. I
need to find
the last used cell for my range to replace A23456
everytime I run the
macro.

Can someone quickly write me the code to find the last
cell for my
range?

Cheers.

Andy


---
Message posted from http://www.ExcelForum.com/

.