| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Active Cells
Many thanks..problem sorted!
"Bob Umlas" wrote: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").Value = Target.Row End Sub "Steve" wrote in message ... I note from a previous post that an active cell's reference can be displayed by inserting some code, as follows: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").Value = Cells(Target.Row, Target.Column).Address(False, False) End Sub If I wish to show only the Active Cell's line number, how should this code be changed? Does inserting code like this mess up the Undo function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Active Cells | Excel Worksheet Functions | |||
| Change color of active cells | Excel Discussion (Misc queries) | |||
| How to make only the cells i need active | Excel Worksheet Functions | |||
| Clearing all Active Cells | Excel Worksheet Functions | |||
| Counting only active cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
