Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List referenced columns in formulas?
I have a LARGE workbook that consists of a large block of data copied
out of our database (the "input block"), and a set of formulas that combine the values to produce user-readable results (the "user block"). I don't know beforehand what columns of data in the input block will be referred to by formulas in the user block, that's up to the user. What I would like to do is remove any unreferenced columns in the input block, after the input block is copied in and recalculations complete. I can't seem to find any way to "get all the column references used in this range" sort of method. Any pointers? Maury |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting list of referenced data | Excel Discussion (Misc queries) | |||
Can't view formulas referenced tab | Excel Discussion (Misc queries) | |||
Excel Columns should be referenced in numbers not letters | Excel Discussion (Misc queries) | |||
multiple columns / rows to be referenced through a listbox | Excel Discussion (Misc queries) | |||
How to automatically change the referenced worksheet name in all formulas? | Excel Programming |