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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 10:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com