Code references two different codes (I know I don't make sense)

[floydian]

Please bear with me...

I run a vba code that calls to another vba code remspecial2.
I then have a second code (this is a piece)

Please Login or Register  to view this content.

BUT... it still calls remspecial2.

I'm sure this is very simple.

[extremis]

can you put your entire code?

both for the first and second macro

[floydian]

This is the first part - which could be written much better I'm certain

Please Login or Register  to view this content.

[B]This code calls to the code below

Please Login or Register  to view this content.

[B]Now I have this code (below)

Please Login or Register  to view this content.

This code should calls to the code below (and this is where the problem is... it goes back and re-initiates the sCompareRows()

Please Login or Register  to view this content.

[JosephP]

how do you know it calls the other code? are you stepping through your code?

[floydian]

Yes... I have been stepping through the code.

When I get to the .Formula = "=CONCATALL(A2:AA2,""|"")" - it jumps to Remspecial

[JosephP]

set calculation to manual

[floydian]

Here is the entire first code:
I wanted to see what was breaking it and I pasted it all together and I get "Compile Error Lable not defined at "GO TO EXIT HANDLER". when I placed the code (in blue) at the bottom. Everything else runs perfectly when that piece of code is not in here!

Please Login or Register  to view this content.

[JosephP]

remove the End Sub from the blue section

[floydian]

That did in fact allow the code to run!
Thank you JosephP

Now on to the next issue (which continues) when we get to the area which calls the "CONCATALL" code... it still calls the "remspecial2".