Sub or Function not defined

[lchk]

Hi everyone,

As a beginner, I am facing a problem in VBA programming: yesterday the macro was working fine and today it is not. Indeed I have the msg box telling me that "Compile error: Sub or Function not defined".

I have looked on google, but I hardly see how the references would be impacting any of this and I did not change much of the code so I don't know where it can come from.

Here is my code. Btw if you have any remarks on my code, please let me know, i'm still in the learning process.

Please Login or Register  to view this content.

Thank you for your help, I know my code is far from perfect, but I just want it to work.
Cheers~



EDIT***
So i actually changed the second line 'Workheets("VAR NUM").Activate' and deleted it so it worked. I would like to understand why activating a specific worksheet in an open file makes it not work anymore... can somebody clarify this please?

[romperstomper]

Simple typo:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

[lchk]

God, how can I be blind at this point. Sorry for disturbing and thanks.

[romperstomper]

Don't worry - we've all been there.

[snb]

Please Login or Register  to view this content.