LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Links Curtis Excel Worksheet Functions 3 November 4th 09 11:12 PM
Removing Intermediary Links FARAZ QURESHI Excel Discussion (Misc queries) 0 January 3rd 09 07:01 AM
Locating Links and Removing rmcompute Links and Linking in Excel 1 May 21st 07 02:12 PM
Removing links Dino Excel Worksheet Functions 2 October 5th 05 05:11 PM
Removing links Jon Excel Programming 1 January 22nd 04 11:21 PM


All times are GMT +1. The time now is 11:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"