How can I use "Ctr + G" + Num , jump to some column which I needed ?

[Prectice]

suppose：

"Ctr + G " + D300 , and , active cell will come to " D column and row #300 "

and If I wand to go to Column 3000 and row #3 , How can I type , If I use the combine key " Ctr + G " !?

e.g.

"Ctr + G " + 3000,3 ??
and how could I calculate " column 3000 " is stand for alphabet which word ? like : ACC ?? CCA ??

 

[sheetspread]

I'm not sure Goto accepts numerical column references (maybe there's a way but......)

This macro assigned to ctrl-q is pretty close:

Sub Macro1()
Dim x As String
x = InputBox("Go Where?")
Range("a1").Offset(Left(x, InStr(x, ",") - 1) - 1, Mid(x, InStr(x, ",") + 1, 250) - 1).Select
End Sub

e.g. type 4,8 for H4

 

[mikerickson]

You could use this macro, just assign Ctrl+G to this macro.
Note that, in addition to A1 style references, this accepts R1C1 references.
The OP cell would be gone to by entering R3c3000

Sub test()
    Dim uiResponse As String
    Dim gotoCell As Range

    uiResponse = Application.InputBox("GoTo Address (A1 or R1C1) or Special", Default:="Special", Type:=2)

    If uiResponse = "False" Then
        Exit Sub: Rem cancel pressed
    ElseIf LCase(uiResponse) = "special" Then
        Application.Dialogs(xlDialogSelectSpecial).Show
    Else
        On Error Resume Next
        Set gotoCell = Range(uiResponse)
        If gotoCell Is Nothing Then
            Set gotoCell = Range(Application.ConvertFormula(uiResponse, xlR1C1, xlA1))
            Set gotoCell = Range(Application.ConvertFormula(uiResponse, xlA1, xlR1C1))
        End If
        On Error GoTo 0
        
        If gotoCell Is Nothing Then
            Beep
        Else
            Application.Goto gotoCell
        End If
    End If
End Sub

 

[thisoldman]

OFFSET() and INDIRECT(ADDRESS()) formulas work in the GoTo dialog. =OFFSET($A$1, 2, 2999) takes you to cell $DKJ$3, row3 column 3000. =INDIRECT(ADDRESS(3, 3000)) takes you there too.

 

[Peter_SSs]

Might not suit but if you change your Excel Options to R1C1 style ...

For Excel 2010: File -> Options -> Formulas -> R1C1 reference style. There is a keyboard combination (hardly a shortcut) to toggle this: Alt+T O F Alt+R Enter
Then Ctrl+G -> R3C3000 -> Enter


Also (not mouse-free without macro) but if you do click in the Name Box to the left of the formula bar, you can type R3C3000 in there & press Enter, even when Excel is in A1 style.

 

[pgc01]

Also (not mouse-free without macro) but if you do click in the Name Box to the left of the formula bar, you can type R3C3000 in there & press Enter, even when Excel is in A1 style.

Thanks Peter

I'm one of the (rare ) ones that like to use the R1C1 notation but I did not know that the namebox accepts it even if the application notation is set to A1. Very handy.

 

[AkaTrouble]

if you want to create a ctrl code to highlight NameBox rick shows good link here

http://www.mrexcel.com/forum/excel-questions/705040-what-hotkey-highlight-name-box.html