Edit: Split from solved nine-year-old topic, since amlbl's problem/solution may be different and a new poster requires a new topic to discuss their problem. -- MrProgrammer 2020-01-10 07:40 UTC |
In my simplified text sheet (see attached doc), I have …
1. A cell B1 withe a named array defined for it (the name is Veld1)
2. A cell A1 with a call to a simple user defined function ( =TESTPROC("Veld1")) which returns the parameter
3. The function, before returning the parameter, searches for the NamedRanges of the curren document
When starting the document, I run into a runtime error (see attached doc).
When the same function call is added to an other cell when the sheet is completely build, there is no problem.
I think that the NamedRanges object is created after the creation of the first sheet.
Is this assumption correct and/or is there a solution for my problem (making the example working correct when starting the document)?
Thks