Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Removing Links | Excel Worksheet Functions | |||
Removing Intermediary Links | Excel Discussion (Misc queries) | |||
Locating Links and Removing | Links and Linking in Excel | |||
Removing links | Excel Worksheet Functions | |||
Removing links | Excel Programming |