How to delete the Object/Picture

[simplyeshu]

Hello Frens,

Can someone help me with VBA code to delete object/picture in the sheet...

I have written a code to delete some data in it but its not deleting the object.

When i am selecting the picture i am getting as

picture -767

 

[mikerickson]

Record a macro of you selecting the picture and deleting it. That should give you the syntax for deleting pictures.

 

[simplyeshu]

I am new to VBA... Could you please give me the steps

 

[mikerickson]

Open the Developer Tab, press Record Macro
(pre-2007 use the Tools > Macro > Record New Macro ... menu item)
Select the picture
Delete the picture
Press the Stop Recording button.
Press Macro on the ribbon (or Tools > Macro > Macros...)
Select Macro1 from the list and press Edit
Change Shapes("Picture -767") to Shapes(1)
Close the VBEditor and return to Excel.