What increases? File size?

The chart names assigned by Excel continue to increase. There's a kind of
memory of previously used shape numbers. This in itself does not indicate a
problem.

Are you deleting the chart objects on the sheet, or merely deleting the rows
or columns under the charts? If you delete the ranges, the charts will
remain, but scrunched into the top or side edge of the deleted range. You
can't see them because they are aligned with cell boundaries. You should do
something like

ActiveSheet.ChartObjects.Delete

at the beginning of your code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"xyfix" wrote in message
oups.com...
I have a excel sheet on which I place 5 charts, through vb code. Every
time a button is pressed, the code removes all charts on the sheet and
creates new ones with new data. Although the number of charts stay the
same and nothing is added extra to the sheet, it increases everytime I
press the button. It looks to me like the charts are not removed, but
stuck on the background ( not visible). If I look at the properties of
the new charts, the chart number doesn't start with number 1 as I
expect it to do.