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