festdaddy wrote:

Thanks Auric,
My biggest problem is I can't figure out why saving personal.xlsb
changes the results of the cell that calls the function. Is this some
kind of bug? If it wasn't totally clear in the first post: When I call
the function from a cell formula, it works fine. If I then save
personal.xlsb from within vba, my sheet is recalculated and the correct
answer changes to an incorrect one.

Do you perhaps have some code in personal's Workbook_BeforeSave event? That's
the only thing that comes to mind.

(Yes, I believe that it *might* be a bug somewhere... but almost certainly
not in Excel.)

--
I hate everyone equally.