Finding out which cell changed

4 views
Skip to first unread message

Komatose

unread,
Jun 9, 2000, 3:00:00 AM6/9/00
to
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

unread,
Jun 9, 2000, 3:00:00 AM6/9/00
to
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

Reply all
Reply to author
Forward
0 new messages