Variable definition problem

Hello all,

In my efforts to learn and use tools well beyond my understanding, I've run into an issue, go figure. Below is some code I've seen elsewhere and which was tried and true in the workbook I acquired it from, however, it's no longer working in my own workbook. Variable not defined is the error I'm getting but I thought the variable was already defined, per the code below.

Any assistance is greatly appreciated. Since I'm still a beginner, I'm oblivious as to what I've done wrong and/or why.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance,

-Orestees

Try the following:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I've tried the sugegsted code but I'm getting a "Compile error: Duplicate declaration in current scope."

-Orestees

Maybe take out the

Please Login or Register  to view this content.