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

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

ActiveCell.SpecialCells(xlLastCell).Select

will get me to the last line.. but i need to jump down to the next line
and start in the A col.

thanks


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

sheets("sheet2").cells(rows.count, "A").end(xlup).offset(1,0).select

--
HTH...

Jim Thomlinson


"sungen99" wrote:


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

Thank you!


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

Don't use last cell. It may not be what you think it is (if you delete rows
or clear content that last cell is not reset until you save).

Ardus makes a a point in his code of selecting the sheet prio to selecting
the cell I neglected to mention that in my code and it is necessary if you
want to select (I personally avoid selecting as much as possible as it slows
the code and is unneccesary).
--
HTH...

Jim Thomlinson


"sungen99" wrote:


ActiveCell.SpecialCells(xlLastCell).Select

will get me to the last line.. but i need to jump down to the next line
and start in the A col.

thanks


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

Hello to every one!
I just wanted to ask the same question, but someone did. Good! but I tried
Jim's and Ardus solutions but both gave me an error. I guess Ardus's macro is
missing a parenthesis but I am wondering where to close this parenthesis and
Jim's formula did not for me??? Am I doing something wrong? I just copied and
pasted the formula to see how it works but it did not!

Thanks for you help in advance!
Chuck

"sungen99" wrote:


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