Hi
How can I write an array formula in VBA? I know how to put an array formula
into a worksheet but I'd like to get the result without having to do that.

More specifically I'd like to get the result from the following formula and
assign it to a variable without writing it to a cell

{=max(len(a1:a1000))}

TIA
;-)