This is going to be a bit strange, so bear with me...

I have a report that consists mostly of formulas pointing to a large
"block" of data pasted into the sheet starting at column BA. The data
in question comes from our SQL based accounting engine via a stored
proc. I call the proc, use GetRows, rotate the array (is there a built
in function for this?) and the paste it in starting at BA5.

Now over in cols A to Z is the "user area" where the user types in
whatever formula they want, mixing and matching the accounting data as
they see fit.

The problem is that there are about 140 columns of data in the
accounting dump. This makes the spreadsheets rather large, about 10
MB. What I would like to do is find out which columns are actually
being referred to from the formulas, and delete any that aren't being
used.

So, is there a way to do this?

Maury