If Not Intersect(Target, [incrRange]) Is Nothing Then use brackets around incrRange, just the way I posted it. Jim
-----Original Message----- From: Windows Home/SOHO [mailto:[EMAIL PROTECTED] Behalf Of Slattery, Tim - BLS Sent: Monday, April 17, 2006 4:32 PM To: [email protected] Subject: Re: onClick for cell in Excel OK, getting closer. I'm using right-click now and the macro is getting run. But it blows up on the "If Not Intersect..." line. If that line looks like this: If Not Intersect(Target, "IncrRange") Is Nothing Then Then I get a "Type mismatch" error, and it points at the character string "IncrRange". If I remove the quotes, so it looks like this: If Not Intersect(Target, IncrRange) Is Nothing Then Then I get an "Object required" error. IncrRange exists, so what do I have to do to get the macro to understand that I want to refer to that range? -- Tim Slattery [EMAIL PROTECTED] -- ---------------------------------------- To Change your email Address for this list, send the following message: CHANGE WIN-HOME your_old_address your_new_address to: [EMAIL PROTECTED] Note carefully that both old and new addresses are required. -- ---------------------------------------- To Change your email Address for this list, send the following message: CHANGE WIN-HOME your_old_address your_new_address to: [EMAIL PROTECTED] Note carefully that both old and new addresses are required.
