Macro to move to a column

[Gavin Ling]

Hi, I need a macro that I can assign to a button so that it will jump the screen to a particular cell.

However, I want it to select the cell in a chosen column in the same row as the cursor already was. So, if I'm in M10 and I hit the AK button, it'll jump to AK10.

If I'm in F54 and I hit the AK button it'll jump to AK54.

Any ideas??

Gavin