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