| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to display current row number in fixed cell?
(New VBA-user!)
I want to have the current row number displayed in a fixed cell. Could you please give me a hint? OldBoy |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to display current row number in fixed cell?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("D1").Value = ActiveCell.Row End Sub "OldBoy" wrote in message . .. (New VBA-user!) I want to have the current row number displayed in a fixed cell. Could you please give me a hint? OldBoy |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to display current row number in fixed cell?
Great!
Thanks a lot. OldBoy "Jim May" wrote in message news:gamKe.16296$MZ6.9262@lakeread01... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("D1").Value = ActiveCell.Row End Sub "OldBoy" wrote in message . .. (New VBA-user!) I want to have the current row number displayed in a fixed cell. Could you please give me a hint? OldBoy |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to display current row number in fixed cell?
Found also this one:
=cell("row") OldBoy "Jim May" wrote in message news:gamKe.16296$MZ6.9262@lakeread01... Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("D1").Value = ActiveCell.Row End Sub "OldBoy" wrote in message . .. (New VBA-user!) I want to have the current row number displayed in a fixed cell. Could you please give me a hint? OldBoy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to display current page number in any cell of that page. | Excel Discussion (Misc queries) | |||
| Display page number in footer based upon pages in the current tab | Excel Discussion (Misc queries) | |||
| Can I format a number display with a fixed exponent? | Excel Discussion (Misc queries) | |||
| DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS | Excel Discussion (Misc queries) | |||
| how do i display the total number of days in the current month in. | Excel Discussion (Misc queries) | |||
Hybrid Mode
