Row number and Column number

  • Thread starter Thread starter Philosophaie
  • Start date Start date
P

Philosophaie

I would like to know how to display the row number and column number of the
currently highlighted cell.
 
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 ;)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column number of last column that returns value ignore formulas 8
Problem with a loop and column references 27
Copy columns and paste with blank column between 5
i = row number of last occurance of duplicate string Column A 4
Count occurances in a range. 5
Compare two worksheets in the same workbook and highlight difference 7
Find Specific Rows in Range and Create New Tab 18
Comparing numbers 1

Back
Top