Cursor Movement Macro

Posted by Susan Corleto on September 17, 2001 1:08 PM

Hello,
I am trying to write a macro that will bring me to the first cell in the next new row, regardless of where I am when I run it. I have tried numerous variations, but cannot make it work. Any help would be greatly appreciated.
Thanks,
Susan

Posted by Juan Pablo on September 17, 2001 1:53 PM

I haven't tested this, but something like this should work:

Sub Movement()
Range("A65536").End(xlUp).Offset(1,0).Activate
End Sub

Actually, it works... i just tested it.

Juan Pablo

Posted by Susan Corleto on September 17, 2001 8:04 PM

THANK YOU SO MUCH. I was at my wits end :)