#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.
|
|