LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Max
 
Posts: n/a
Default

Maybe you'd like to check out these 2 previous posts by Leo Heuser, where he
provides 2 VBA subs to deal with it.

Sub DeleteUnusedStyles()
http://tinyurl.com/mmrd

Sub DeleteUnusedCustomNumberFormat*s()
[version 1.01]
http://tinyurl.com/37vz7

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"jimhallen" wrote in message
...
Dana,

I tried Microsoft's "Cleaner" but it didn't help. I have the same

problem,
my spreadsheet has
grown over time and I'm bumping up against the 4000 cell format limit.

Have
you found
any ways around it?

Jim Allen



 
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
numeric cell formats David McColloch Excel Discussion (Misc queries) 1 January 8th 05 11:15 PM
Cell Formats in formulas C. Lewis Excel Discussion (Misc queries) 1 January 5th 05 06:37 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM
Too Many Different Cell Formats Nanette Excel Worksheet Functions 7 November 15th 04 08:53 PM
Too Many Different Cell Formats Nanette Excel Worksheet Functions 1 November 12th 04 04:55 AM


All times are GMT +1. The time now is 12:34 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"