Ambiguous name detected error

[jpxexcelforum]

Why do I have that error?

Please Login or Register  to view this content.

[TMS]

It's ambiguous because you have *two* "Private Sub Workbook_SheetChange" events.

You need to combine the tests within one "Private Sub Workbook_SheetChange" event.

Regards

[jpxexcelforum]

It's ambiguous because you have *two* "Private Sub Workbook_SheetChange" events.

You need to combine the tests within one "Private Sub Workbook_SheetChange" event.

Regards

Can you show me how? I'm new to coding.

[TMS]

One way:

Please Login or Register  to view this content.

Regards

[TMS]

In actual fact, each section should be structured like:

Please Login or Register  to view this content.

This is because you are making changes to the sheet within the change event.


Regards

[jpxexcelforum]

Thanks. The first one didn't work though, I tried it. I tried the second one. Is this correct?

Please Login or Register  to view this content.

[TMS]

In what way didn't it work?

I would have expected it to work but it would have gone through the routine more times than it needed to.

The second example looks OK ... but, if the first attempt failed, I don't see why this would be any more successful.

Regards

[TMS]

This works as I would expect it to:

Please Login or Register  to view this content.

Regards

[jpxexcelforum]

Works great! I saw where I made a mistake. I linked a cell to the same offset. This is exactly what I needed.

Thanks a lot! Mods please consider this thread solved! Thanks again TMShucks!!

[romperstomper]

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

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