If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
reset chart names
I have a VBA function that will copy 12 charts from various workbooks into a
single workbook. I run this macro once a month. Before I run the macro I delete all the charts from the single workbook. After running the macro I notice that the chart names (e.g. 1,2,3,...) increase by the number of charts I copy. For example when I first ran the macro the charts in the single workbook were named 1 ..12. After deleting the charts in the single workbook and running the macro again the charts are named 13..24. Is there a way to reset the chart names so they are always 1..12 in the single workbook? |
#2
|
|||
|
|||
reset chart names
After deleting the charts, and all shapes on the sheet (if you want to keep
any temporarily cut/paste them to another sheet), save the workbook, close it, reopen it. That's the only way I know to reset the object counter. ] Regards, Peter T "Scott" wrote in message news I have a VBA function that will copy 12 charts from various workbooks into a single workbook. I run this macro once a month. Before I run the macro I delete all the charts from the single workbook. After running the macro I notice that the chart names (e.g. 1,2,3,...) increase by the number of charts I copy. For example when I first ran the macro the charts in the single workbook were named 1 ..12. After deleting the charts in the single workbook and running the macro again the charts are named 13..24. Is there a way to reset the chart names so they are always 1..12 in the single workbook? |
Thread Tools | |
Display Modes | |
|
|