Active Macro behaving Inactively?

[EverGreen1231]

I sorry for my somewhat unintelligible title, but I really had no other idea as how to word it.

Here's my dilemma.
I'm trying to break a gargantuan code into a number of smaller to medium sized codes. However, when I call on the "Copy_before_STAT" Macro I get a run time '1006' error (or 1004 ...can't remember) telling me that this macro is not enabled. However when I run the same Macro (Copy_before_STAT) unaccompanied, it works splendidly.

Below is my main code.

Please Login or Register  to view this content.

here's the code for the Copy_before_STAT Macro

Please Login or Register  to view this content.

I must tell you, I do not claim to be a well versed VBA sage capable of solving the worlds numerous and impossibly large problems, but I do ok for a laymen.

I would be much obliged if someone could give me elucidation on this matter.

Thank you in advance,
-Tyler.

[Izandol]

Macro is called "Copying_before_Stat" not "Copy_before_STAT"

You do not require Run - you may use Call:

Please Login or Register  to view this content.