Error with chart using vba

[Sean Thomas]

Hi,
Can anyone give me an idea whats happening here?

Part of my code copies a sheet, inserts it before a worksheet with a chart on it
It then errors before renaming the new sheet
I cant understand why it is causing the error

Please Login or Register  to view this content.

error appears in worksheets("Charts") for the highlighted code

Please Login or Register  to view this content.

it gives runtime error 91
Object variable or with block variable not set
In debug there is a value in ChartName

[AndyLitch]

Do you have an EndIf after the EndWith ??

[Andy Pope]

There is no leading . in front of ChartTitle.

[Sean Thomas]

Yes there is,
All i can think of is when i insert the new sheet, its activates the worksheet with the embedded chart and causes the combobox1 change event to occur, but i cant understand why it errors. the combobox1 code works perfectly to update the chart with different data based on dropdown value.
here is the full code from the offending worksheet that errors. I have ammended it slightly and now it errors at
.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Andy Pope]

Not in your first post there is not.
How can we guess what the error is if you post code that is different to the code you are using??

Post an example, rather than snippets of incorrect code.

[Sean Thomas]

Thanks Andy,
there is a . in front, however i accidently deleted it when changing the font colour in the thread.

[JosephP]

perhaps avoid activating

Please Login or Register  to view this content.

[Sean Thomas]

Thanks JP, that worked.
I tried that earlier, but for some reason i was getting an error.
Thinking about it i still had the chart.activate line still in, but change the with part.

All sorted now, so thanks again.