How to delete MSOSHAPELEFTARROW only

[mhni]

Using VBA Excel, I am having a hard time deleting ONLY specific shapes (they are all left Arrows and are situated in range E10:E20.

I am trying to delete JUST these msoshapeLeftArrow that are located in that range of the worksheet without deleting any other shapes like buttons and drop down boxex etc....

I was trying:

Please Login or Register  to view this content.

This is not working because the above code deletes EVERY shape in my worksheet.

Thanks

[lecxe]

Hi mhni

Try:

Please Login or Register  to view this content.

[mhni]

Works like a charm....many thanks!