GO TO

N

nir020

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
 
H

Harlan Grove

Jerry W. Lewis said:
Try

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

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
 
Top