Delete Pics help from Excel-anauts

Ever copy a table from an ASP page? And the table had some pictures of your friends mean cat in it that you didn’t want?

Here’s some help with that, from Google Groups:

  1. Open the workbook
  2. select that worksheet
  3. hit alt-f11 to get to the vbe
  4. hit ctrl-g to see the immediate window
  5. Type Activesheet.pictures.delete and hit enter

It won’t say anything or give you feedback telling you it worked, but go back and check your excel. No mean cat pictures. Wooo! Excel-anauts assemble!

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

This site uses Akismet to reduce spam. Learn how your comment data is processed.