I recalled a value from a cell in a worksheet and VBA is telling me that it cannot use it. It automatically renamed it and I don't know why. Here is my code:
It renames the 'K' variable to 'K-factor'. I do not have a variable named 'K-factor' anywhere. How can I fix this?
Please Login or Register to view this content.
Thanks
Last edited by damayn83; 01-21-2013 at 11:01 AM.
What is "K" declared as at the top of your macro?
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
I dimensioned "K" as single and the problem is still occuring. very confusing.
I was able to fix it. Had to correct what cells the program was refferencing. Completely overlooked that fact.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks