If cell value changes in 2 cells
In your Worksheet Change event put something like this
if Not Intersect(Target,Me.Range("E5")) is Nothing then
'Do the events for E5
end if
Repeat for H5
HTH,
Barb Reinhardt
"Kashyap" wrote:
Hi, I have a set of tasks to be done when value in E5 changes.. but I need to
do another set of tasks when value in H5 changes as well.. How to go around
it?
|