G Guest Sep 4, 2004 #1 when i try to change the formate of a cell i get "to many cell formates displayed"
F Frank Kabel Sep 4, 2004 #2 Hi for dealing with too many cell formats have a look at the following KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;213904
Hi for dealing with too many cell formats have a look at the following KB article http://support.microsoft.com/default.aspx?scid=kb;en-us;213904
D David McRitchie Sep 9, 2004 #3 Leo Heuser posted a macro 2001-05-06 in programming as a major revision of his earlier macro in the eee007 article. http://google.com/groups?selm=OxP9cgi1AHA.1572@tkmsftngp02 The macro gets rid of unused formats. Slow Response, Memory Problems, and Speeding up Excel http://www.mvps.org/dmcritchie/excel/slowresp.htm#formats
Leo Heuser posted a macro 2001-05-06 in programming as a major revision of his earlier macro in the eee007 article. http://google.com/groups?selm=OxP9cgi1AHA.1572@tkmsftngp02 The macro gets rid of unused formats. Slow Response, Memory Problems, and Speeding up Excel http://www.mvps.org/dmcritchie/excel/slowresp.htm#formats