| Mobile | RSS

Delete Pics help from Excel-anauts

October 6th, 2009 | No Comments | Posted in software

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

Time limit is exhausted. Please reload the CAPTCHA.