Hi
The change event occurs whenever some entrie is changed - no way to bypass
this. You have to check the range the changed cell belongs to at very start
of code, and depending the check result take further actions or exit the
event - thus minimizing the VBA activity.
It's the reason, I myself use Change event very reluctantly. It can
considerably slow down your worksheet sometimes.
--
Arvi Laanemets
(When sending e-mail, use address arvil<Attarkon.ee)
"crazybass2" wrote in message
...
Frank was able to help with the selection change event, but I only want to
trigger the event when I've made a change in a row.
I'm looking for code that would create a "Worksheet_Change" event only
when
a change of row occurs.
See "Change of Row event" for more details.
|