Well, as Chip uses a lot of array formulas on that page, these would
probably take a very long time to calculate given the scenario you
outlined above.

However, you can record a macro and then enter the formula in a cell
and then close the macro, and then you will see how it is done.

Pete

On Apr 9, 1:26*pm, NPell wrote:

I dont know how to transfer Formulas to Macros though.
Thanks for looking though