I have a group of pictures in a range that i need to resize and paste on another sheet. Is there a way to do this with a macro? I basically want to scale everything down without it look weird. In example 4 pictures make up a square and i still want it as a square when it repaste.

Thanks