Delete shapes in a range macro not working

[snoopyngd]

Hi,

I have this macro which gives me an error: Application-defined or object-defined error. Can someone help me out?

Please Login or Register  to view this content.

[snb]

Is this also erroring ?

Please Login or Register  to view this content.

[Andy Pope]

Guess Gantt Chart is not the active sheet.

Please Login or Register  to view this content.

[snoopyngd]

Andy,

It is still giving my an error. In the line I highlighted below.

Please Login or Register  to view this content.

[snoopyngd]

Hi snb,

I am not sure if I understand the code. Is it a full code or just part of it?

[Andy Pope]

you need to post a workbook that illustrates the problem.

[snb]

It's full code.
You can test it.
But I second Andy: post a workbook.