Multi-sheet range references

Add-in Express™ Support Service
That's what is more important than anything else

Multi-sheet range references
Does Excel support passing them to UDFs? 
bobcalco




Posts: 66
 Joined: 2019-03-20
I am asking here about this kind of reference which is common for a handful of Excel built-ins:

=SUM('Grill5-01:Grill5-08'!B5)

Can such a "3D reference" be consumed in a UDF in Add-in Express? It seems supported at most by a handful of Excel built-ins, and my experience (read: experiments) with VBA and ExcelDNA suggests the answer is "no." VBA sees such a range as Variant/Error 2015, and ExcelDNA reports any such argument as ExcelError.

Can Add-in Express handle such input, or is it simply not possible?
Posted 03 Dec, 2021 22:09:43 Top
Andrei Smolin


Add-in Express team


Posts: 19030
 Joined: 2006-05-11
Hello Bob,

The Excel object model doesn't support such 3D references.

Regards from Poland (CET),

Andrei Smolin
Add-in Express Team Leader
Posted 06 Dec, 2021 10:12:38 Top