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 fin
the last used cell for my range to replace A23456 everytime I run th
macro.

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

Cheers.

And

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