S
SpaceCamel
Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.
Thanks,
ie, Column "G" is column 7.
Thanks,
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
=column(g1)
?????
Or just put
=column()
in any cell in column G.
?????
Or just put
=column()
in any cell in column G.
D
Dave F
You can have the column letters appear as numbers.
Tools--options--general--R1C1 reference style.
You can also populate the first row of cells with numbers, A1=1, B1, =2,
etc., and freeze that first row. To do this select teh 2nd row, then
Window--Freeze Panes.
Finally, you can use the COLUMN function =COLUMN(D1) returns 4, etc.
Dave
Tools--options--general--R1C1 reference style.
You can also populate the first row of cells with numbers, A1=1, B1, =2,
etc., and freeze that first row. To do this select teh 2nd row, then
Window--Freeze Panes.
Finally, you can use the COLUMN function =COLUMN(D1) returns 4, etc.
Dave
D
Dana DeLouis
I was just hoping for a tooltip or statusbar display
One idea...While working on a particular sheet, you could place this code on
that particular sheet module in vba.
It will display the R1C1 address in the status bar.
When you are finished working on the sheet, you could remove it.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Address(True, True, xlR1C1)
End Sub
One idea...While working on a particular sheet, you could place this code on
that particular sheet module in vba.
It will display the R1C1 address in the status bar.
When you are finished working on the sheet, you could remove it.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Address(True, True, xlR1C1)
End Sub