MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Can i hve two target as range?


Posted by Jonny D on February 12, 2002 2:22 PM

Is it poss to have to target as range ie
Private Sub Worksheet_Change(ByVal Target As Range)

Canthis be set to two cloumns or many cells ie A1 B3 H4 and so on

Many thanks

John


Posted by Derek on February 12, 2002 5:43 PM

Private Sub Worksheet_Change(ByVal Target As Range)
John
One way is:
If Target.Address = "$A$1" Then Whatever
If Target.Address = "$B$3" Then Whatever
If Target.Address = "$H$4" Then Whatever
End Sub
Derek