Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Multiple Style in Excel 2003

4,660 views
Skip to first unread message

Nimesh

unread,
Jul 9, 2009, 10:07:01 AM7/9/09
to

I have received file from other user, it has more than 1500 styles. Many a
times I am not able to apply my style in the file and shows error of Too many
style.
I tried to remove one by one but it take too long time and I have many such
files.
Is there any way for multiple selection of styles and than can delete it.

Bob Phillips

unread,
Jul 9, 2009, 10:24:59 AM7/9/09
to

Dim mpStyle As Style

For Each mpStyle In ActiveWorkbook.Styles

If Not mpStyle.BuiltIn Then

mpStyle.Delete
End If
Next mpStyle


--
__________________________________
HTH

Bob

"Nimesh" <Nim...@discussions.microsoft.com> wrote in message
news:6DECD830-D2DD-481F...@microsoft.com...

Jim Cone

unread,
Jul 9, 2009, 1:34:37 PM7/9/09
to

My Excel add-in "Formats & Styles" will list or delete unused
number formats and styles in the active workbook.
(not tested on xl2007)
It may do what you want. It is free upon email request.
I ask that you use your real name and provide your geographic location.
Remove xxx from my email address: james....@comcast.netXXX
--
Jim Cone
Portland, Oregon USA

"Nimesh" <Nim...@discussions.microsoft.com>
wrote in message

jonathan...@gmail.com

unread,
Jun 20, 2012, 5:54:33 PM6/20/12
to
THIS WORKED GREAT! Thanks!
0 new messages