I am trying to perform a calculation but instead i get either crazy results or no results at all. It is the first function i created, so i guess the mistake is either when declaring it or calling it. How is it fixed? The procedure:
Please Login or Register to view this content.
I think we need more to go on, such as an example where you think it is wrong.
Good luck.
Hmmm, first i thought it was in the calling procedure. I guess its in the numbers declaration.Originally Posted by OnErrorGoto0
Tried with Long and Double but it didnt work.
I have range from 0.001 to 2000.000
If you need decimals, then you need Doubles not Longs. Other than that we need a specific example that you think is wrong.
Message box says that CO2em is -1 while it had to be 71.887Please Login or Register to view this content.
Excel and windows decimal symbol problem?
That code makes no sense. Can you post the complete code? (note that EFCO2 is supposed to be one value, not an array)
Also crossposted here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks