Simple Macro to go to column... dont know where to start....

[MikeyFB]

Hello

I want to make a simple macro shortcut that takes you to a column.

So say im in Cell H8, i want to push a short cut (say ctrl+m), and it take me to cell BD8.

I know you could just use the box in the top left, but trying to stay keyboard based.

Help.

 

[VoG]

Try assigning this to a shortcut key combination

Sub Move()
ActiveCell.Offset(, 48).Select
End Sub

 

[CWatts]

That would only work if you're in the example cell, but if you're in any other cell, depending on your preferred result, you can try these:

Puts BD8 in the top left most corner:

Sub Move()
    Application.Goto Reference:=Range("BD8"), scroll:=True
End Sub

Just moves toward BD8

Sub Move2()
    Range("BD8").Select
End Sub

 

[MikeyFB]

Hello

Thanks for the answers.

There are benifits to both, but also downsides.

If i am in H2 id want to go to BD2.

If i am in H18 id want to go to BD18.

If i am in C18 id want to go to BD18.

So the row im in needs to stay the same.

Thanks

 

[VoG]

Try

Sub Move()
Range("BD" & ActiveCell.Row).Select
End Sub