Macro - Moving Mr Cursor

  • Thread starter Thread starter Voodoodan
  • Start date Start date
V

Voodoodan

Hello,

I have a listing in one column. I have set up a macro so that when I
open the worksheet the last cell in that column is selected. However,
I want to move down to the next cell.

Has anyone got any ideas on how to move the cursor down one cell
without having to specify the range?

Thanks,
Dan.
 
Chip,

It worked perfectly, and so easily done!

I tried recording a macro and pressing the down arrow, but perhaps it
wasn't as logical as I had hoped!

Thanks very much,
Dan.
 
There are innumerable ways to reference a particular cell. Over time, one
tends to find his own personal preference. I prefer using the _Default
property I posted, but there is nothing wrong with using Offset.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com (e-mail address removed)


GB said:
As far as I can see, these also work:-

ActiveCell.Offset(1, 0).Range("A1").Select
ActiveCell.Offset(1, 0).Select
ActiveCell.Range("A2").Select

Anything against these, apart from using more keystrokes than Chip's
solution?

(I hope I'm not wasting your time - I'm just trying to get to grips with
VBA.)
 
Back
Top