MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Ambigous name detected Private Sub Worksheet_Change


Posted by Jim on September 02, 2001 9:56 AM

Hello:
I need to use Private Sub Worksheet_Change twice in the
same Sheet2 code, I've tried a few differant things with no
luck, any ideas?
Thanks, Jim


Posted by Dax on September 02, 2001 10:04 AM

Can I ask why you need two subs? How will Excel know which procedure to use? If you explain your problem maybe there's another way around it.

Regards,
Dax.

Posted by Jim on September 02, 2001 10:16 AM


Do you mind if i e-mail it to you?

Posted by Dax on September 02, 2001 11:35 AM

Sure, email to me and I'll have a look.

Regards,
Dax.