Hi Excel users and expert,

Excel 2002 SP3.

I swear I have seen the answer to this but Google search did not get me
there.

I'm looking for code that does this:

If active cell is in named range Data1 then call Macro1
elseif activecell is in named range Data2 then call Macro2
End If

"activecell.name.name" did not work but I have to missing something. Gotta
be fairly simple.

I have 9 ranges and macros but I'm sure if I can get the syntax of the 2
above I can work it out.

Thanks,
Regards,
Howard