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

Hi, Mangus-
Thanks for your response. Here's the long version of the story: as you
may know Excel can generate a "Too many cell formats" error in a
formatting-intensive sprdsht. I've written some code to go thru the
back office tabs of this workbook and reset formats to generic.

Can't explain why, but when I closed Excel and reopened the same
workbook the code runs fine. And you're right, it's too late and I'm
too tired to fuss with it any longer. I'm willing to chalk it up to
some kind of memory... uh... flux capacitor problem.

Thanks again for your come-back!

 
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
Help: runtime error - Method seriescollection object_chart failed huangx06 Charts and Charting in Excel 3 July 9th 05 12:27 AM
Runtime error for macro that works in workbook created in Crystal Excel Discussion (Misc queries) 1 June 22nd 05 08:43 PM
Excel 2003 Help Runtime Error Weezay Excel Discussion (Misc queries) 1 January 27th 05 06:57 PM
Excel help giving runtime error Hari Prasadh Excel Discussion (Misc queries) 1 January 21st 05 01:23 PM
Why do I get the runtime error message430 when I start my compute. Thorcat Setting up and Configuration of Excel 1 December 2nd 04 07:15 PM


All times are GMT +1. The time now is 12:43 PM.

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"