an example:

dim lastrow as long
lastrow = Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row

range("A" & lastrow).value = 1
--


Gary


"edward0380" <edward0380.230skm_1139586002.1003@excelforum-nospam.com> wrote in
message news:edward0380.230skm_1139586002.1003@excelforum-nospam.com...
>
> 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
>