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? |
|
Andrei Smolin
Add-in Express team
Posts: 19018
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 |
|