Easy Question - Cursor Down

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I want to place the cursor in Excel at the end of a range
of data ready to enter new data (Using an Add cmdButton).

This is from a macro when typing [Shift-Down Arrow].

Selection.End(x1Down).Select

What I want to add to this is to simply cursor down one
more cell. Recording the action in a macro has the cell
reference ** Range("C779").Select ** as an exact location
which the macro will return to even when 20 more rows have
been populated.

Is there a method to referentially cursor down 1 at the
end of the data?

Thanks!!!
 
there's probably a better way, but this works:

Selection.Offset(1, 0).Select

to move one cell right, switch the 1 & 0
 
...
...
This is from a macro when typing [Shift-Down Arrow].

Selection.End(x1Down).Select ...
Is there a method to referentially cursor down 1 at the
end of the data?
Click to expand...

Selection.End(xlDown).Offset(1, 0).Select
 
Back
Top