compile error ambiguous name detected worksheet_change

**MAttTaylor87** · 07-22-2013, 05:17 AM

Hi All,

First time query from myself. I am currently trying to use two Worksheet_Change subs in my code but keep getting an error saying "compile error ambiguous name detected". I know from reading previous threads that this is because I can not have two Worksheet_Change queries in one sheet. Would anybody be able to help me combine the following pieces of code please.

If cell AJ13 shows “AA” I want to hide certain rows and if it shows “AB” I want it to hide others.

The first change is...

Please Login or Register  to view this content.

And the second change is...

Please Login or Register  to view this content.

Any help you could provide would be much appreciated

Thanks,
Matt

**TMS** · 07-22-2013, 05:46 AM

Maybe:

Please Login or Register  to view this content.

Regards, TMS

**MAttTaylor87** · 07-22-2013, 06:41 AM

Hi,

This is perfect. Thank you very much. I have made a slight tweak as I have other variables where neither AA or AB will show and I need all unhidden. I just added another level, AC which has unhidden all.

Thank you very much for you quick response and help with this.

Cheers,
Matt

**TMS** · 07-22-2013, 06:45 AM

You're welcome.

I'm glad you were able to adapt it to meet your needs.

And my apologies ... I should have said "welcome to the forum"!

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

**MAttTaylor87** · 07-22-2013, 06:53 AM

All done

Thanks again.

**TMS** · 07-22-2013, 07:07 AM

Thanks ... and thanks for the rep

compile error ambiguous name detected worksheet_change

LinkBack

Thread Tools

Rate This Thread

Display

compile error ambiguous name detected worksheet_change

Re: compile error ambiguous name detected worksheet_change

Re: compile error ambiguous name detected worksheet_change

Re: compile error ambiguous name detected worksheet_change

Re: compile error ambiguous name detected worksheet_change

Re: compile error ambiguous name detected worksheet_change

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] compile error ambiguous name detected!?

[SOLVED] Compile error: Ambiguous name detected: Worksheet_Change

[SOLVED] Compile Error: Ambiguous Name Detected: Workbook_BeforeClose

compile error: Ambiguous name detected :worksheet_change

Compile error: Ambiguous name detected

Bookmarks

Bookmarks

Posting Permissions