[Chicago] VBA sucks (or is it Excel?)
Ishmael Rufus
sakamura at gmail.com
Thu May 1 00:46:23 CEST 2008
"VBA sucks (or is it Excel?)"
No, the only people who suck are:
-- The programmer that created the InRange function
-- The programmer that was responsible for the VBA operators
-- The QA team that didn't throughly test math precision on all of the
functions.
I'm sure you've heard about the Famous Excel 2007 bug.
rcriii at ramsdells.net wrote:
> >From the VBA immediate window:
>
> print InRange(row, Col)
> 39543.4993171296
> print searchval
> 39543.5
> print InRange(row, Col) >= SearchVal
> True
> print 39543.4993171296 >= 39543.5
> False
>
> I know this isn't python, but I had to share.
>
> Robert
>
> _______________________________________________
> Chicago mailing list
> Chicago at python.org
> http://mail.python.org/mailman/listinfo/chicago
>
More information about the Chicago
mailing list