Macro - Moving Mr Cursor

[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 Pearson]

Dan,

Try something like

ActiveCell(2,1).Select

 

[Voodoodan]

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.

 

[Chip Pearson]

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)

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.)