Using Win 2003 and Office XP;

Is it possible to internally calculate an array formula? By that I mean not
in a sheet, but in memory. For example by using
Application.WorksheetFunctions you can access certain functions in code then
write the result into a sheet. Any ideas how to do this using an array
formula?

Thanks for the help.

As an example

myVal = Activesheet.Evaluate("=SUM(IF(A1:A5=""Apple"",B1:B5))")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"XP" <(E-Mail Removed)> wrote in message
news:985D2332-96E7-4102-AC6E-(E-Mail Removed)...
> Using Win 2003 and Office XP;
>
> Is it possible to internally calculate an array formula? By that I mean
> not
> in a sheet, but in memory. For example by using
> Application.WorksheetFunctions you can access certain functions in code
> then
> write the result into a sheet. Any ideas how to do this using an array
> formula?
>
> Thanks for the help.

Perfect. Thanks Bob!

Hope you escaped the flooding in Yorkshire and elsewhere...


"Bob Phillips" wrote:

> As an example
>
> myVal = Activesheet.Evaluate("=SUM(IF(A1:A5=""Apple"",B1:B5))")
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "XP" <(E-Mail Removed)> wrote in message
> news:985D2332-96E7-4102-AC6E-(E-Mail Removed)...
> > Using Win 2003 and Office XP;
> >
> > Is it possible to internally calculate an array formula? By that I mean
> > not
> > in a sheet, but in memory. For example by using
> > Application.WorksheetFunctions you can access certain functions in code
> > then
> > write the result into a sheet. Any ideas how to do this using an array
> > formula?
> >
> > Thanks for the help.
>
>
>

Being 300 miles away, it didn't affect me too much.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"XP" <(E-Mail Removed)> wrote in message
news:E05068B2-A370-4274-A01F-(E-Mail Removed)...
> Perfect. Thanks Bob!
>
> Hope you escaped the flooding in Yorkshire and elsewhere...
>
>
> "Bob Phillips" wrote:
>
>> As an example
>>
>> myVal = Activesheet.Evaluate("=SUM(IF(A1:A5=""Apple"",B1:B5))")
>>
>> --
>> HTH
>>
>> Bob
>>
>> (there's no email, no snail mail, but somewhere should be gmail in my
>> addy)
>>
>> "XP" <(E-Mail Removed)> wrote in message
>> news:985D2332-96E7-4102-AC6E-(E-Mail Removed)...
>> > Using Win 2003 and Office XP;
>> >
>> > Is it possible to internally calculate an array formula? By that I mean
>> > not
>> > in a sheet, but in memory. For example by using
>> > Application.WorksheetFunctions you can access certain functions in code
>> > then
>> > write the result into a sheet. Any ideas how to do this using an array
>> > formula?
>> >
>> > Thanks for the help.
>>
>>
>>