sub lastRow()
Worksheets("Sheet2").Activate
range(cells(rows.count,"A").end(xlup).offset(1,0). Select
end Sub

HTH
--
AP

"sungen99" a écrit
dans le message de news:
...

Just need a simple macro please.

goto sheet2 and place the cusor at A(whatever is the last line of data
+1)


thanks very much.


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=540357