Selecting an area of sheet and removing all pictures

[cuewoz]

As the title says

I have a sheet which generates pictures at various intervals which are the tops of pages.

After using once and running again the pictures are still there and more are created on to of these.

Is there any code you can use which can select say A1 to J100 and delete all text and pictures in 1.
This is because You would not know what the pictures are called as it is the same thing repeating its self

Thanks
Warren

[Leith Ross]

Hello Cuewoz,

This macro will delete all pictures it finds in the given Range. Add a Standard VBA Module to your Workbook and then copy and paste the macro code into it.

Please Login or Register  to view this content.

Example:
DeletePic Worksheets("Sheet1").Range("A1:J100")

Sincerely,
Leith Ross