Steve Rowe wrote:I've a piece of code that I'm developing and on Friday when I finished working on it all was OK..
Now it isn't...
Spent an age tinkering with it trying to figure what is happening.
Part of the script is to remove TM1 formula from the workbook and the macro is basically the TM1 Tools macro from elsewhere on the forum.
When it gets to the
the script throws an Object required error.
I don't understand why this error is being generated and I think it's false positive some how. If I run the TM1Tools macro which is the same script it does not error.
The other strange thing is that when I step through the code it seems to execute the line twice, only generating the error on the second execution of the single line.
Any clues as to what it is going on, I'm pretty competent at VBA so this has got to be something pretty unusual or broken...
Tried restarting etc, but this is the same macro that my virus scanner was interfering with and Iâ€™m wondering if the compiled version of the script has got corrupted. Anyone know how I can force a full recompile?
Users browsing this forum: No registered users and 1 guest