Hi,

I have a line of code that identifies the last active row of a
worksheet, ready for a new record to be added.


Code:
--------------------


Range("A65536").End(xlUp).Offset(1, 0).Select


--------------------


For example purposes assume that that new row is row 30.

How do I then tell Excel to move to column J in row 30, not stay in
column A?

I cant just change the range selection to J because not all rows have
inputs in row J but all new entries do have a column A entry.


--
Alec H
------------------------------------------------------------------------
Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042
View this thread: http://www.excelforum.com/showthread...hreadid=522139