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:B 5))")

--
HTH

Bob

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

"XP" wrote in message
...
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:B 5))")

--
HTH

Bob

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

"XP" wrote in message
...
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" wrote in message
...
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:B 5))")

--
HTH

Bob

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

"XP" wrote in message
...
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.