Hi,
UsedRange can be unreliable for finding the last known row/column.
Also, Rows.Count/End(xlUp) will not look at formulas which return a null
value.
--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.
"galimi" wrote in message
...
range("a1").Offset(sheet1.UsedRange.Row-1).Select
Replace sheet1 with the sheet object name.
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758
"edward0380" wrote:
I want to have a macro that will select the cell in the last row in
column A. How do I do that?
--
edward0380
------------------------------------------------------------------------
edward0380's Profile:
http://www.excelforum.com/member.php...o&userid=29396
View this thread:
http://www.excelforum.com/showthread...hreadid=511077