Reaching nth column from a particular column

[Rakesch]

suppose I am on cell AB4, my next entry is 30 columns after column AB4. what is the way to reach there ?

 

[AliGW]

Erm ... Tab right 30 times?

 

[AlanSidman]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 28 Then
Target.Offset(0, 30).Select
End If

End Sub

 

[GraH - Guido]

Hmm, might be if you protect your sheet and you don't allow locked cells to be selected, you'd use simple TAB to jump over 30 protected columns.

Or when using R1C1 ref style, you can type R40C58 in the name box followed by enter to get there.

Same can be done with A-style reference, but adding up from AB + 30 is what? Thus slightly more difficult.
Just recall there was a post on this in the lounge a couple of months to a year ago.

 

[bosco_yip]

In cell AB4 >> press "Ctrl+G" >> in the "Go To" Reference box enter :

=INDIRECT(TEXT(428+30,"R0C00"),0)

>> click "OK"



Regards
Bosco

 

[Peter Bartholomew]

Guido
I sometimes get into disgrace when a suggest that A1 notation is a piece of utter garbage. Why one would wish to move from the well-tried strategy of numbering columns to referencing by letters of the alphabet is a mystery (yes, I know that is the way it is done on tatty town plans). The column labels do not even have the good grace to form an alphabetically ordered sequence (really wanted evil grin!)