View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Awill Awill is offline
external usenet poster
 
Posts: 4
Default Alternatives to Application.evaluate(Long Formula)

Thanks for the reponse. I tried breaking the string or formula into smaller
parts, evaluate the small part and then incorporate it back into the original
formula.

The difficulty is that the variables are arrays so I have a lot of trouble
trying to incorporate the calculated array (from evaluating a portion of the
formula) back into the original formula for calculation.

Any ideas for incorporating the array back into a string formula for
calculation with application.evaluate?

"Gary''s Student" wrote:

Split the formula up into smaller strings.
--
Gary''s Student - gsnu200713