evaluate("=MAX(LEN(A1:A1000))")

--

HTH

RP

"Loomah" <bellm AT globalnet dot co dot uk wrote in message
...
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
;-)