Forum Discussion
Using dynamic arrays to populate named ranges for ListBox Controls is unstable - user error?.
I will work on that later today (Friday) UK-time and send over with a short description of the data model and the business logic that the workbook contains. Watch out for that being attached in my reply. Appreciate your time on this.
Thanks
Rory
Hi JoeMcDaid
Pulling my hair out now with this forum platform. I've submitted my reply after a lot of effort which is a lengthy explainer about the workbook sample and it's now disappeared (my reply with workbook) from the thread.
I'm attaching the workbook again but I don't have time right now to re-write the explainer - I wish I'd done it in Word rather than type direct into the forum rich text editor; but ah well, lesson learned.
Here is the workbook. It's a simple cascade from q1 to q3 but I have to put the data through lots of gyrations - I have counted 11 dynamic array formulae on the face of the Proto worksheet before we start thinking about these being repeated in Named Ranges to be recycled into ListBox controls.
Take a look and ask me any questions.
Much appreciated.
Rory