Active Cells

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

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?
 
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Target.Row
End Sub
 
Steve,

If by line you mean row then try this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Target.Row
End Sub
Does inserting code like this mess up the Undo function?
Click to expand...

Yes

Mike
 
Many thanks..problem sorted!

Mike H said:
Steve,

If by line you mean row then try this

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A1").Value = Target.Row
End Sub


Yes

Mike
Click to expand...
 

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

Excel Worksheet_change with 2 functions to insert date and hyperlink window 0
Trying to run excel vba code when cell value changes from empty to entered value. 1
Two variables for Target.Value 5
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Excel Need assistance with modifying a Duplicate declaration. 13
Excel Msgbox runing beyond posted cell range. 1
Calendar default date 2
Deleting row using vb code? 4

Back
Top