List referenced columns in formulas?
On Feb 23, 1:02*pm, JLGWhiz wrote:
Check out the Precedents and Dependents properties. *Maybe you can work with
that.
As it turns out, you can! The one annoyance is that Precedents returns
an error instead of null if there are none in the range, which means
you have to use a trap. Other than that it's pretty easy to use.
Simply loop over the area you're interested in, ask for a range's
Precedents.Areas, and record which columns are in use. Then delete the
ones that aren't. Excel's formula re-writer fixes everything up as
they're removed.
It cut my spreadsheet by about 10% in size.
Maury
|