[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