Excel SDK: Finding array formula bounds

[Jonathan Rynd]

Using the Excel SDK (i.e. the Excel4 macro language), how can I
(a) how can I determine if the present cell is part of an array formula?
(b) if I know that the current cell is part of an array formula, how can I
determine the range that is the output of the current array formula?

Basically, emulate VBA's "CurrentArray" method of the Range object.

Or is Automation the only way to get that information?

 

[Stephen Bye]

I don't have the docs to hand, but I believe that the Excel4 CALLER function
returns this information.

 

[Jonathan Rynd]

I don't have the docs to hand, but I believe that the Excel4 CALLER
function returns this information.

Unfortunately I forgot to mention something in my post. I am not writing a
worksheet function; I am writing a command macro/subroutine (it is run by
clicking on a toolbar button; it then makes changes to the worksheets). So
CALLER wouldn't work for me.

Thanks for the suggestion, though.