Cursor Navigation Help

Hi All,

I've had a couple of questions answered tonight, you guys have been a great help!

Very last question before I hit the sack.

Riddle me this....

If the following code moves the cursor 1 place to the left,

Please Login or Register  to view this content.

What would I need to change in order for the cursor to be moved 1 row up and 1 cell to the right.

I've tried multiple changes, but to be honest I'm just guessing.

Thanks all.
Darren

Hi Joseph,

Unfortunately does not have the desired effect, cursor does not move.

Darren

Hi Joseph,

Same non movement on cursor, but this time it crashed excel,

Darren

It clearly must be me causing the error as this code doesnt seem to work either.

Darren

Originally Posted by MarvinP

Hi Darren,

The guys above are a lot smarter than I am.
Where your current cursor is at is given by:

Cells(Activecell.Row,Activecell.Column)

If you want to go one row down and 2 rows to the right you would do a:

Cells(Activecell.Row + 1 ,Activecell.Column + 2).Select

I don't like or use the "Offset" statement much. I like to use the "Cells( row , column)" notation.

Hi Marvin,

I think the issue is that I only want move if the cell is not locked

The funny thing is that the very first piece of code works correctly for moving to the first unlocked cell to the left.

Just trying to do exactly the same thing but moving up 1 row and across 1 cell to the right.

Darren

Hi Marvin,

Your suggestion actually worked perfectly, much simpler method.

Thanks again
Darren