P
Philosophaie
I would like to know how to display the row number and column number of the
currently highlighted cell.
currently highlighted cell.
P
Patrick Molloy
you could use the row() and column() function.
so maybe use the selection change event to show this is?
right click the sheet tab and select View Code from the popup and paste in
this code ...
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Address
MsgBox Target.Address, , "you selected..."
End Sub
delete the ksgbox line when it gets too irritating
so maybe use the selection change event to show this is?
right click the sheet tab and select View Code from the popup and paste in
this code ...
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Address
MsgBox Target.Address, , "you selected..."
End Sub
delete the ksgbox line when it gets too irritating
G
Gord Dibben
Look at NameBox when selecting a cell.
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP