macro

[Pam]

I have a large worksheet, and I created a macro that when
ran would take me to a new row at the bottom of my
worksheet for input. For some reason it works exactly as
intended for the first time, then the second time it just
repeats the same routine on the same row, preventing the
user to advance to a newly formatted row. Help!

 

[Alan]

It would be easier to answer if you post your code,
Regards,

 

[Peo Sjoblom]

What you probably did was to record a macro while you selected the
first empty cell.

If you want to select the first empty cell in A you can use

Selection.End(xlDown).Offset(1, 0).Range("A1").Select

for some more info see

http://www.mvps.org/dmcritchie/excel/lastcell.htm