does anybody reccomend any add-in and/or best practice to grapple with long
command statements ?

All the best,

Alex

Not sure what you're asking here. Are you referring to long formulas in the
formula bar?

The best way to understand their logic is to split the formula into
bite-size chunks, understand what those chunks do, and then figure out how
all of them work together.
--
Brevity is the soul of wit.


"Alex" wrote:


does anybody reccomend any add-in and/or best practice to grapple with long
command statements ?

All the best,

Alex

Thanks Dave

Acctually I was looking for ways (by meand of add-ins &/or best practices)
of accomplishing the parsed understanding of a too-long formula in the
formula bar.

It seems there are 2 alternatives for that:

1) Using Excel Formula Evaluator ( Tools=Formula Auditing=Evaluate Formula)

2) Selecting the cell, pressing F2, higlight a portion of the formula and
pressing F9

All the best,

Alex

"Dave F" wrote:

Not sure what you're asking here. Are you referring to long formulas in the
formula bar?

The best way to understand their logic is to split the formula into
bite-size chunks, understand what those chunks do, and then figure out how
all of them work together.
--
Brevity is the soul of wit.


"Alex" wrote:


does anybody reccomend any add-in and/or best practice to grapple with long
command statements ?

All the best,

Alex