Ambiguous name detected problem

[mukeshbaviskar]

Dear Friends,
Please solve the problem of ambiguous name detected problem in 'access' sheet code. Thank you.

Mukesh

[jaslake]

Hi mukeshbaviskar

You have two Private Sub Worksheet_Change(ByVal Target As Range) macros...you'll need to combine them.

[mukeshbaviskar]

Thank you but how to combine it. I'm getting error. Please combine and attach a revised file.

Thanking you in anticipation.

Mukesh

[jaslake]

Hi mukeshbaviskar

Show me what you tried...we'll try to fix it. Make certain to wrap Code in Code Tags.

[mukeshbaviskar]

Hello jaslake,
I have edited the code and I think it is perfect do run the macro. The macro is working fine. Do check it and let me know whether it's a right way to combine two or more macros.
I want to add more macros to this sheet. So please guide me where to add those macros to avoide error.

Thanking you in anticipation.

Mukesh

[jaslake]

Hi mukeshbaviskar

I've looked at your Code and, if it works, don't change it.

It appears fine to me...I'd suggest the Sub SearchForDuplicates() belongs in a General Module but what the hey, does it work? If so, leave it where it is,