Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula in memory
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula in memory
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula in memory
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array formula in memory
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
array storage in memory | Excel Programming | |||
create an array with unique items IN MEMORY | Excel Worksheet Functions | |||
Out of Memory: Array Transpose | Excel Programming | |||
does Excel have memory limit of data Array? | Excel Programming | |||
Excel: Array & Memory | Excel Programming |