Finding out which cell changed

[Komatose]

Hi All

Given the following:

Private Sub Worksheet_Change(ByVal Target As Range)

How do you find out which cell has changed and whether only one
cell has changed or have multiple cells changed.

Thanx Koma Tose

* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
The fastest and easiest way to search and participate in Usenet - Free!

[Efstratios Malasiotis]

Hi Koma Tose,

You could possibly use something like:
-------------------------------------------
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
MsgBox Target.Address & vbCr & IIf(Target.Cells.Count > 1, "Multiple", "Single")

End Sub
------------------------------------------

HTH
Stratos