thanks Andy. It worked !!
Kamal On Thu, Aug 6, 2009 at 5:22 PM, Aindril De <aind...@gmail.com> wrote: > Dear Kamal, > > Just add the following line to the top of your code to select all pictures > in the worksheet > > ActiveSheet.Pictures.Select > > Hope this helps. > > Otherwise please post your code here so that we can take a alook. > > Regards, > Andy > > On Thu, Aug 6, 2009 at 4:51 PM, kamal shah <kamal...@gmail.com> wrote: > >> Hi Excel Gurus, >> >> I am looking for help to solve one of mechanical process in Excel sheet. >> I have more than 50 screeenshots pasted in Worksheet (as part of Business >> evidence). >> I wish to reduce (Image) Size by 50 % of all screenshots pasted in >> worksheet in one go. >> >> I did play around with Macro and could achieve doing it in one click ( >> Plain record and Play kind of macro) but I get stuck up to select all images >> in worksheet. >> >> any help on this will be highly appreciated. >> >> Kamal >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
