GO TO

[Guest]

Is it possible to create a Macro which when activated will move the active
cell to the equivalent cell in the same row in a different columns.

E.g. If the user is in cell A25 if the macro is run the user will be moved
to cell AA25

Thanks

 

[Jerry W. Lewis]

Try

Sub move2I()
Cells(ActiveCell.Row, 9).Select
End Sub

Jerry

 

[Harlan Grove]

Try

Sub move2I()
Cells(ActiveCell.Row, 9).Select
End Sub ....

Picky: Jerry's macro would move from A25 to I25 rather than AA25. If there's
a pattern to this, and you'd also want to move from AA25 to BA25, then
perhaps

Sub foo()
ActiveCell.Offset(0, 26).Select
End Sub