+ Reply to Thread
Results 1 to 11 of 11

resize images in a Range

  1. #1
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    resize images in a Range

    Hi All,

    is it possible to resize images (in the range A100:A4000) with 25%?

    Thanks for the comments

    Greetings,

    Danielle

  2. #2
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: resize images in a Range

    Hello
    Do you mean that you want to select multiple images that have been pasted in your selected range and re-size them all in 1 go, instead of selecting and re-sizing individually ?

    Regards
    Most helpful to mark solved items as such (see help for directions). Star ratings are always welcome.

  3. #3
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: resize images in a Range

    Repeated message, please ignore this one, pressed the button twice
    Last edited by hamjam; 08-06-2013 at 10:05 AM.

  4. #4
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: resize images in a Range

    Hello,

    Do you mean that you want to select multiple images that have been pasted in your selected range and re-size them all in 1 go, instead of selecting and re-sizing individually ?
    Yes, is that possible with a VBA code?

    Greetings,

    Danielle

  5. #5
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: resize images in a Range

    Hello
    You could try something like this :
    Please Login or Register  to view this content.
    Regards

  6. #6
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: resize images in a Range

    Thanks

    Greetings,

    Danielle

  7. #7
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: resize images in a Range

    Hello
    Welcome, that does all the images in the worksheet. If you need to only select specific images, you need to provide the names.

    But perhaps this will suffice in your case.

    Regards

  8. #8
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: resize images in a Range

    Hi,

    I want select the pictures in a range: I use this code:
    Please Login or Register  to view this content.
    But that is not working.

    Greetings,

    Danielle

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: resize images in a Range

    This tests the shape is within the given range.
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  10. #10
    Forum Contributor
    Join Date
    01-07-2013
    Location
    south africa
    MS-Off Ver
    Excel 2003-13
    Posts
    210

    Re: resize images in a Range

    Hello
    I see we got an expert on it, perhaps just modify Andy's code to your range, i.e. set rngInRange to your A1 to AG100 and give it a bash.
    Thanks Andy

    Regards

  11. #11
    Forum Contributor
    Join Date
    07-10-2013
    Location
    Veendam
    MS-Off Ver
    Excel 2007
    Posts
    100

    Re: resize images in a Range

    Thanks all for the VBA code.

    Greetings,

    Danielle

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. macro to resize multiple images
    By Blake 7 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-14-2012, 12:14 PM
  2. Code to resize images in a file?
    By USGS in forum Excel General
    Replies: 1
    Last Post: 12-29-2011, 06:21 AM
  3. Code to resize images maintaining ratio
    By simjambra in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2009, 06:30 PM
  4. scan resize + cheek to see if there are scaned images
    By D_Rennie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-03-2009, 05:41 AM
  5. Import And Resize Images
    By 2eXtreme in forum Excel General
    Replies: 6
    Last Post: 02-05-2006, 12:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1