Array formula in memory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Perfect. Thanks Bob!

Hope you escaped the flooding in Yorkshire and elsewhere...
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Wildcard in Excel array formula 0
Array to Multiple Arrays 3
Code a long array formula 2
Recalculating Array Formulas 1
Array formula does not calculate correctly when run from macro 10
Using an array formula as a hyperlink cell reference 3
How to read Excel Array to vb.net Arrays? 20
Alternative to Application.Caller in array functions to avoid wrong results? 10

Back
Top