Finding out the cell using VBA


Posted by Brian on February 11, 2002 11:22 AM

How do I find out what cell was used in the following?

Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox "The cell is " & Target
End Sub

Target is the value of the cell. How do I find out what cell it came from?

Thank you,

Brian

Posted by DK on February 11, 2002 11:23 AM

Re: Target.Address (NT)



Posted by Brian on February 11, 2002 11:25 AM

Thank you!(NT)