Add some circular references in there somewhere and the fun can begin

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Biff" wrote in message
...
As best as I can calculate, you have a total of 38,845 calls to INDIRECT.

Is there a specific reason you're using INDIRECT(col_ref & ROW()) to
define a cell reference?

Those INDIRECT calls are killing you!

If you add or delete any of the entries in columns AA-AH,
you will see the result in the Numbered List.

I'm afraid to do anything that'll trigger a calculation!

Biff

wrote in message
ups.com...
I am just trying to find a simpler way of providing the automatic
numbered list that is seen in columns S-Z. If you add or delete any of
the entries in columns AA-AH, you will see the result in the Numbered
List.

Geoff.