View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz[_2_] Maury Markowitz[_2_] is offline
external usenet poster
 
Posts: 119
Default 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