copy one array formula to an array range

's Computer Specifications

Hi,
I am looking for a function that will copy the full result of on array
formula (that I do not know haw big the output is) to an array in memory.

Many thanks.

Paul

's Computer Specifications

Dim v as Variant
v = DateRate(ben)

--
Regards,
Tom Ogilvy

"guedj54" <(E-Mail Removed)> wrote in message
news:AF023E66-65FC-4E2F-808F-(E-Mail Removed)...
> Hi,
> I am looking for a function that will copy the full result of on array
> formula (that I do not know haw big the output is) to an array in memory.
>
> Many thanks.
>
> Paul

's Computer Specifications

Thanks again

"Tom Ogilvy" wrote:

> Dim v as Variant
> v = DateRate(ben)
>
>
> --
> Regards,
> Tom Ogilvy
>
>
>
>
> "guedj54" <(E-Mail Removed)> wrote in message
> news:AF023E66-65FC-4E2F-808F-(E-Mail Removed)...
> > Hi,
> > I am looking for a function that will copy the full result of on array
> > formula (that I do not know haw big the output is) to an array in memory.
> >
> > Many thanks.
> >
> > Paul
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy array to range	Stefi	Microsoft Excel Programming	2	18th May 2009 08:37 AM
Fast copy method of sub array (=array range) possible?	Thomas Lebrecht	Microsoft VB .NET	0	19th Mar 2009 08:49 AM
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order)	Keith R	Microsoft Excel Programming	3	13th Nov 2007 04:08 PM
Tricky array formula issue - Using array formula on one cell, then autofilling down a range	aspenbordr	Microsoft Excel Programming	0	27th Jul 2005 03:59 PM
Comparing ARRAY elements with RANGE data and created a 2nd array	JimP	Microsoft Excel Worksheet Functions	2	10th Mar 2004 07:29 PM