Forum Discussion
PeterBartholomew1
Dec 09, 2024Silver Contributor
Working with Arrays of Ranges
OK, so strictly speaking an array of ranges is an error in Excel right from the outset. However, I set up an array of tables contained within the named Range 'allocatedRange', here shown with a red...
PeterBartholomew1
Dec 09, 2024Silver Contributor
I have updates the file to show the thunk array as #CALC! errors when output to the worksheet and also evaluated to show their content (Edit does not seem to be an option on the original post).