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" <ed@HelpExcel.com> wrote in message
news:CDA74E02-35FF-4860-AC0A-C6742CA42C74@microsoft.com...
> 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
>>
>>