| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row number and Column number
I would like to know how to display the row number and column number of the
currently highlighted cell. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row number and Column number
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 ;) "Philosophaie" wrote: I would like to know how to display the row number and column number of the currently highlighted cell. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row number and Column number
Look at NameBox when selecting a cell.
Gord Dibben MS Excel MVP On Thu, 8 Oct 2009 02:20:01 -0700, Philosophaie wrote: I would like to know how to display the row number and column number of the currently highlighted cell. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use a Number times an X anh have a column with that number of x's | Excel Discussion (Misc queries) | |||
| How do I count the number of each number in a column? | Excel Discussion (Misc queries) | |||
| row number and column number of cell | Excel Programming | |||
| how i write a number on a column A and see that number on letters. | Excel Worksheet Functions | |||
| Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Linear Mode
