Movement of the cursor

[tran1728]

Dear All, i need your help pls,

This is really basic but I could not find a thread. I want to control the
movement of the cursor. move direct at A6 after the last row of column A.

Column A
A1 Item
A2 9800
A3 9800
A4 9800
A5 9800

Thanks so muck

 

[JLatham]

I'm not sure exactly when you want to move down to the last row. After
typing an entry into a cell in column A?
If that's the case, look at:
Tools --> Options --> [Edit] tab and then check the box next to:
"Move selection after Enter" and then pick "Down" from the direction list.

In Excel 2007/2010 this is in the Advanced group of the options.

If this doesn't solve your problem, please explain a little more about
exactly when you want to go to the bottom of column A.

 

[Jacob Skaria]

Could you please elaborate..That depends on where the cursor is right now..

If in cell A1; press Ctrl+ DownArrow

If in cell A6; press Ctrl+ UpArrow

 

[Jacob Skaria]

You are asking for a VBA solution. Check your other post

Cells(Rows.Count, "A").End(xlUp).offset(1).select

 

[tran1728]

Yes, thank you.

You are asking for a VBA solution. Check your other post

Cells(Rows.Count, "A").End(xlUp).offset(1).select