Defined variable problem

[mikeymay]

I have a macro that execute with a Worksheet_Change event but before it starts I get a 'User-Defined type not defined' error, which when I click on 'OK' kicks off the code and executes with no issues.

I am struggling to flush this out and not entirely sure what to do.

After a bit of research I have established that I have the correct references checked so I don't think this will be the root of the problem.


Thanks

 

[jmthompson]

Please post your code

 

[mikeymay]

There is quite a lot of code so didn't think this was a sensible thing to do initially.

I have asked someone else to test the file and it was established that a line of code containing a declared variable has a character missing which was corrected.

This then allowed the user to run the code without the error being returned, yet I still got the error.

I have re booted and tried again but I am still gettin gth error.

If the code is still required I can post it all.


Thanks

 

[Ruddles]

Let's see the DIMs and CONSTs first. And show us the line which was corrected.

If it's a huge amount of code I'm happy to take a look at it and the post my finding publicly. I'll PM you my address.