View Single Post
 
Old 11-27-2015, 05:30 AM
Officer_Bierschnitt Officer_Bierschnitt is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Oct 2015
Posts: 87
Officer_Bierschnitt is on a distinguished road
Default

Hi,

I have a module of its own called "Declarations" where all I do is declare all of the variables needed in any of the other modules. No variables are declared anywhere else - except the ones that I really need in only one procedure, variables that I need throughout one module are declared in that module, too.
I will just try using another variable in the places where that error occurs ... Let's see.

P.S.: Now it's happening with another variable, >> v_path_total << - strangely, the error always occurs upon the first mentioning of the variable in a procedure. Can it be that I must not populate the same variable first with one, then with another value (twice or more altogether) in the same procedure? No, actually not, in a subroutine I use one variable and re-populate it with different values four times in a procedure ...

I have also just restarted my entire machine, sometimes something gets stuck somewhere and that helps ... but it did not in this case.

I'm really at a loss about this. Luckily, I have left the "original" file with the macro intact and I am experimenting on a copy, so it will work on Monday ...
Reply With Quote