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

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.



"tran1728" wrote:

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

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 (MVP - Excel)


"tran1728" wrote:

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

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

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

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

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 (MVP - Excel)


"tran1728" wrote:

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

Yes, thank you.

"Jacob Skaria" wrote:

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

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

--
Jacob (MVP - Excel)


"Jacob Skaria" wrote:

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 (MVP - Excel)


"tran1728" wrote:

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