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/
.