Named Range Error (Need help troubleshooting and fixing)

[onthegreen03]

Hi. I have a tab that I am trying to copy to a new file. The tab I am trying to copy has one named range, the new file does not. When I copy the tab into the new file I get #NAME? errors in all of the cells with formulas. What do I need to do to get this tab to copy over to the new file without any cell errors? (The formulas work fine in the tab before I move it.) Let me know if you need more information to help troubleshoot the issue, and thanks for the help.

 

[onthegreen03]

OK, looks like you have a lot more going on there.
Are you sure that there aren't any cells/formulas/ranges on this sheet trying to references cells from other sheets?

What might be a better option is to simply re-save the file with a new name, and then delete the sheets you don't need.
If you still get errors, that is a big clue that your sheet is referencing things on other sheets.

Okay, I resaved the file and there are no other tabs (hidden or unhidden), so it's just the one working tab. Inputs and formulas all work perfectly, there is only one named range under Name Manager. When I try to copy the tab into the a new workbook the cells with the formulas all error out (#NAME?). Very strange. I'd be happy to send the file to you, it is not proprietary. Would love to figure this out ... maybe with the file you can troubleshoot and fix. Let me know. Thanks for the help.

 

[Fluff]

What does the refers to in the named range show?

 

[onthegreen03]

What does the refers to in the named range show?

See below.

 

[Fluff]

Thanks for that, I susoect that both Uptake & ModelStartDate are both UDFs

 

[onthegreen03]

Thanks for that, I susoect that both Uptake & ModelStartDate are both UDFs

If they are UDFs, is that what is preventing me from copying the sheet into a new workbook without the errors? Is there anyway to fix this or do I simply abandon this mission?

 

[Fluff]

You will need to copy the UDFs to the new workbook.

 

[onthegreen03]

You will need to copy the UDFs to the new workbook.

Okay, dumb question. I went into the existing sheet and looked under "Queries and Connections" thinking the UDFs would be there but none were listed. Am I looking in the wrong place?

 

[Fluff]

They will be in a VBA module, to find them them hit Alt F11 to open the VB editor & then loo in the various modules & you should find them.

 

[onthegreen03]

Found them, thank you Fluff and everyone who helped. Much appreciated!

 

[Fluff]

Glad we could help & thanks for the feedback.