Re: #REF when creating an Addin

Tech-Archive recommends: Fix windows errors by optimizing your registry

Post your code and the type of formulas.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"stewdizzle" <smccallister@xxxxxxxxx> wrote in message news:1167877146.251818.67210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|I am creating and addin that when opened will copy itself into an
| existing workbook. From there the copied work*** is supposed to pull
| data from another work*** and allow the user to manipulate it. I
| created the work*** 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 work*** 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 work*** is copied into
| the existing workbook it references the cells properly.
|


.

Quantcast