Can you post that macro?


Thx,
JP

On Nov 20, 3:18 pm, ilia wrote:
I start by building the formula separately, each intermediate result
(what I consider intermediate) stored in its own cell. Next, I use
find/replace in a text editor to make it into one big formula.

Recently I wrote a macro to do this automatically. It takes a cell,
searches for any references to other cells, and if those cells contain
formulas, it brings them into one, resulting in a megaformula. Its
functionality is limited, but it works for most formulae that have
references on a single sheet and do not contain arrays.

Unless I know exactly what I'm doing, I rarely do everything in one
cell, through the formula bar.