Compile Error: Ambiguous name detected

[trubio77]

Hello,

need some assistance

I keep getting the following Compile Error

"Ambiguous name detected: Worksheet_Change"

here is the code that I run:

Please Login or Register  to view this content.

[Arkadi]

You can't have 2 (or more) separate worksheet_change macros on the same worksheet.

[Arkadi]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[trubio77]

sorry about that

I have corrected

thank you

[trubio77]

Arkadi,

if I am not able to have 2 or more separate worksheet_change macros on the same worksheet, how do I fix this

thank you

[Arkadi]

Your If statements ensure the part inside only runs if the condition is met... so just put all the If blocks in the same change event.

[trubio77]

Arkadi,

not sure how to do that

is this correct

Please Login or Register  to view this content.

[trubio77]

I got it

thank you ..... SOLVED

[Arkadi]

Sorry... had just logged back in to check... glad you solved it, and apologies for not answering sooner.