View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default 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?