C
cereldine
I've rcorded some code that loops through a table and creates a chart on
each column, the chart worksheet is named after a variable myshrttitle
which is driven by a cell value. The code works fine first time and
creates all the charts, what i want to achieve is when the code runs
next time to delete the worksheet with name myshrttitle and then
recreate it?
Is this the correct way to go about the problem?
I name the sheet with the following
ActiveChart.Location xlLocationAsNewSheet, myshrttitle
and was hoping to use something along the lines of
if worksheets(myshrttitle) exists/ is not null then
worksheets(myshrttitle).delete
end if
thanks
each column, the chart worksheet is named after a variable myshrttitle
which is driven by a cell value. The code works fine first time and
creates all the charts, what i want to achieve is when the code runs
next time to delete the worksheet with name myshrttitle and then
recreate it?
Is this the correct way to go about the problem?
I name the sheet with the following
ActiveChart.Location xlLocationAsNewSheet, myshrttitle
and was hoping to use something along the lines of
if worksheets(myshrttitle) exists/ is not null then
worksheets(myshrttitle).delete
end if
thanks