Cycle through each imagine in sheet and change it's height / width ignoring one image?

**Hyflex** · 09-13-2013, 01:51 PM

Anyone know how do the following:

Cycle through every image on a sheet without knowing their picture name OR cycle through Picture 2 to Picture 50 ignoring any what don't exist?

And then setting their width and height to the following:
Selection.ShapeRange.Height = 70.8661417323
Selection.ShapeRange.Width = 87.874015748

Thanks in advance
- Hyflex

**xladept** · 09-13-2013, 02:41 PM

Hi Hyflex,

Try this:

Please Login or Register  to view this content.

**Hyflex** · 09-13-2013, 03:15 PM

How to I make exceptions for image names?

So Picture 1, Picture 2, Picture 5?

Also is it possible to adjust their position from current position down 5 pixels and right 10 pixels?

**xladept** · 09-13-2013, 03:49 PM

Here's one way - if you have a lot of exceptions, we should code it differently

Please Login or Register  to view this content.

Cycle through each imagine in sheet and change it's height / width ignoring one image?

LinkBack

Thread Tools

Rate This Thread

Display

Cycle through each imagine in sheet and change it's height / width ignoring one image?

Re: Cycle through each imagine in sheet and change it's height / width ignoring one image?

Re: Cycle through each imagine in sheet and change it's height / width ignoring one image?

Re: Cycle through each imagine in sheet and change it's height / width ignoring one image?

Thread Information

Users Browsing this Thread

Similar Threads

Change Cylinder Height and Width from a cell value

Can you change a cell's width and height w/ effecting other cells in that row column?

Setting the Height and Width of an Image

Change default height/width of up/down arrow, heading, bottom bar

[SOLVED] How do i change the height and width of a single cell in Excel?

Bookmarks

Bookmarks

Posting Permissions