MrExcel Publishing
Your One Stop for Excel Tips & Solutions

moving 1 cell down


Posted by JOHN on February 07, 2001 9:22 AM

I know this probably sounds really simple to u guys but its a tough 1 for me!

What is the VBA code for moving 1 cell down
I know that to move to the last row you have the code is
Selction.End(1xdown).select
i have experimented with this and have not got it to work.


Posted by Tom Morales on February 07, 2001 11:29 AM

To move one cell down, try

Selection.offset(1,0).select