Formulas to be maintained in Excel / text and passed to macro

[MayurHP]

Hello Team,

My problem statement is that I have to create 80+ formulas. For that either I will have to add 80+ formula tools or else within a single formula tool (or some groups of formula tools) add multiple formulas one below the other.

I wanted to check if there is a way by which formulas could be maintained on Excel / text and inserted on run time via macro

I have checked and it works for a single formula using Batch Macro, however am not sure on how to make it work for large numbers of formulas

Any help is much appreciated

[mceleavey]

@MayurHP ,

yes.

Without showing showing what you're trying to do I can't really advise any further 🙂

It sounds like it could be done in another way. Let us know what you're trying to do and we'll see if we can help.

M.