Try something like
Dim Rng As Range
Set Rng = Cells(Rows.Count, "A").End(xlUp)(2,1)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"DJ Dusty"
wrote in
message
...
Hi,
During the running of my macro, I want the macro to be able to
select
the first blank cell it comes to, at the bottom of a list of
data.
So, if cells A1:A12 contained data, then I'd want cell A13 to
be
selected by the macro.
Any ideas? Must be an easy one for some of you!
--
DJ Dusty
------------------------------------------------------------------------
DJ Dusty's Profile:
http://www.excelforum.com/member.php...o&userid=16335
View this thread:
http://www.excelforum.com/showthread...hreadid=520077