View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jase jase is offline
external usenet poster
 
Posts: 117
Default removing values not links

Hi All

I have a worksheet with around 5000 rows and 10 columns. Held within these
values are formulas and values. I am trying to get some code that removes
all of the values but does not touch the formula's.

I have been able to do this with a big loop, but this takes soooo long it is
ridiculous. I was wondering if anyone else has come up with a more efficent
way of accomplishing this task.

Thanks heaps
Jase