Hi, I can't even begin to describe what's happening to my code. I'm going crazy.
Basically a lot of my previously working code has stopped functioning correctly. I tracked down the bug in this example (see attachment )and I know what is not working, but why?????
Apparently it stops working when it gets to cell A36 for no apparent reason
Please help me...
Last edited by ericds; 12-15-2014 at 03:22 PM.
In what way does it fail for you. It runs (for me) and displays a message box with the value 176.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for having a look,
with me it does not recognize 0.70=0.70, the line 'MsgBox VBAalacon = Merde' displays false for line 36. I don't know what this is.
If it works for you this means it's because my PC is ****, just got a new one from my office. any idea on how to make it the way it was???
Thanks
It's hard to work out exactly what you are trying to achieve...
Looks like there's floating point arithmetic calculation errors happening, though. You can try rounding the values you are comparing.
Unpicking and rewriting your code, does this do what you want?
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Its.. famous.. Double value Precision point problem..
basic of Data Type Conversion..
Check this one..
http://msdn.microsoft.com/en-us/libr...t8(VS.80).aspx
and for further WTF (When you have Time For reading) check this one..
http://www.cygnus-software.com/paper...ringfloats.htm
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Okay, so my code did not work for you too?
I am not trying to achieve anything with this code, I just did not understand why these values are not the same when they look exactly the same? How come there are floating point errors in a numbers that I got from excel (collumn a is generated by pulling down 0 and 0.02)...
your code works, but how is this possible, does this mean each time I compare two values I have to round them off???
Read Debraj's links in post #5.
Wuuuut? this is crazy, I guess i will have to round of everything. I'm gonna rename my thread to the title of your article debraj
I've been using VBA for 3 years now and this is the first time I've encountered this problem...
thanks everyone
edit:
in order to avoid this an option can be clicked somewhere in excel:
http://support.microsoft.com/kb/214118
Last edited by ericds; 12-15-2014 at 03:38 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks