I finished my form which is an architectural calculator.
I'm using one worksheet for calculations. When I save as
an add-in and test loading the add-in, calculations are
being performed on sheet1 of the activeworkbook. I did a
lot of research on net (appearently not enough) and was
warned from Microsoft KB to refer code in add-in to
thisworkbook. So I changed all my code to...

Thisworkbook.Activesheet.Range(".............

Now i get error Object variable or with block variable not
set...

Any ideas?
TIA