After much time spent thinking about this project, I have decided that I
was complicating the situation by trying to put more than one fiscal year
in a workbook. It would be much simpler for those that come after me to
have a workbook for each fiscal year. So, either myself or a moderator can
d
Thanks, that might get me on the right track. I will try it and if I can
get it working then I will post back how it went and mark the thread as
solved.
Your are correct, I didn't use option explicit. When you don't deal with
macros very often you forget a lot.
On Sun, Sep 6, 2015 at 7:54 PM, Pau
I can see a couple of concerns.The LARGEST concern is that "t2" is a variable
called t2.not the value of the cell T2.So, most likely you're not using "Option
Explicit" at the start of your code modules.Therefore, the first time VBA
encounters a variable that has not been declared, it "self-decla
