Excel VBA - declaring a constant as a value that is subject to change
Posted on 2009-04-02
I am having a really funny issue with a variable changing by itself. I think it happens when I modify code near the declaration of that variable: then it resets to zero because VBA thinks I just declared it or something. I wanted to declare a constant as a value that could change later, but I want the constant to stay the same. I want to use a counta function on a range to do that... but I can't seem to use counta in the constant declaration section. Is there any way to freeze a variable's value, even if something attempts to change it later?