hi,
the code doesn't give me an error on the pc (32bit OS) but it intermittently gets an error 80010108 in my lap top (64 bit OS), both excels are 32bit.
the code is:
Please Login or Register  to view this content.
I get the error inside the function: getArea

Please Login or Register  to view this content.
all the functions called in workbook_open are located in a module
when i get the error if go to the code and restart the execution (F5), the code resumes properly without giving the error and i can continue working in the workbook as if it never happened. but, when i close the workbook excel crashes

i used the codecleaner www.appspro.com/Utilities/CodeCleaner.htm , but it only help a little, the error continues appearing, but less often.

thanks for any help