Posted to microsoft.public.excel.programming

Loomah[_2_] Loomah[_2_] is offline

external usenet poster

Posts: 8

VBA Array Formulae

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
;-)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Array formulae do not recalculate	Thanks	Excel Worksheet Functions	3	April 4th 23 11:41 AM
Array Formulae	Chris waller	Excel Discussion (Misc queries)	3	February 12th 09 11:09 PM
IF statement with 2 array formulae	nathan_savidge	Excel Worksheet Functions	1	April 22nd 08 02:47 PM
Using wildcards in Array formulae	John	Excel Discussion (Misc queries)	2	August 17th 07 03:57 PM
OFFSET and array formulae	Wazooli	Excel Discussion (Misc queries)	3	January 20th 05 12:09 AM

All times are GMT +1. The time now is 05:11 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us