LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default Resetting the chart count

Hi,
I've written some code that automatically generates about 30 small graphs.
Periodically these have to be deleted and regenerated. This could happen as
many as 20 times a day. I've noticed that each new chart is assigned a number
which increments by 1 but it does not reset when I close Excel. Although it
does not affect the program, I'm concerned that within a year the count may
grow to a ridiculously large number. Is there any way I can reset the count
back to zero when i close the program.

Thank you
 
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
Chart worksheet names keep resetting dloomer Charts and Charting in Excel 0 December 10th 09 05:58 PM
Slightly Urgent: Problem Resetting Chart Value Ranges LarryP Excel Programming 2 August 5th 08 08:52 PM
Why are my options resetting themselves? cbare Excel Discussion (Misc queries) 0 November 2nd 06 11:30 PM
having the chart NOT count zero Sabrick Charts and Charting in Excel 0 April 1st 06 06:11 AM
Resetting chart ranges Maury Markowitz Excel Programming 0 January 12th 05 04:13 PM


All times are GMT +1. The time now is 03:09 AM.

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

About Us

"It's about Microsoft Excel"