View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default Determine columns used

Use the sheet grouping-ungrouping steps if you wish to kill all the
formulas
in A2:H32 (via an "in-place" copy paste special check "Values" OK),
and clear cells I1:IV1.


The last line should read as:
and then clear cells I1:IV1.


The freezing of the results evaluated by the formulae should be done first.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--