View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default #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.
|