On Sep 8, 10:46*am, Gary''s Student
wrote:
It is clearly possible to loop over the user area, find each equation, find
the precedents of the equations and map them into the data area, and then
delete un-used columns.

So how does one "find the precedents"?

I don't recommend doing this:

I might consider the linked-spreadsheet idea, but I have found in the
past that the slightest network hick makes the links stop working and
random errors start appearing in dialogs. You also start running into
all sorts of problems with locking behavior, which is never a good
thing in Excel.

Maury