#REF when creating an Addin
 

I am creating and addin that when opened will copy itself into an
existing workbook. From there the copied worksheet is supposed to pull
data from another worksheet and allow the user to manipulate it. I
created the worksheet in the same workbook that it will be used in.
Made sure all the formulas worked as desired and that everything was
the way i wanted it to be. However, when I copy the addin worksheet to
a new workbook to actually make it an addin I loose all my references.
How do I change the formulas so that when the worksheet is copied into
the existing workbook it references the cells properly.

#REF when creating an Addin
 

Please don't multi-post

Post your code and the type of formulas.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"stewdizzle" wrote in message ups.com...
|I am creating and addin that when opened will copy itself into an
| existing workbook. From there the copied worksheet is supposed to pull
| data from another worksheet and allow the user to manipulate it. I
| created the worksheet in the same workbook that it will be used in.
| Made sure all the formulas worked as desired and that everything was
| the way i wanted it to be. However, when I copy the addin worksheet to
| a new workbook to actually make it an addin I loose all my references.
| How do I change the formulas so that when the worksheet is copied into
| the existing workbook it references the cells properly.
|