aspect ratio

Hi, I've got this sheet where I've sized the columns, rows & zoom perfectly to fit a header picture on a single screen page where you don't have to scroll to see any of the data. Also, cells were sized specifically to overlay on top of specific parts of the header image. I just opened the same...

Hello, I am attempting to use VBA to crop images to a 1:1 aspect ratio. Here is the code that I am using currently: With shp Width = .Width Height = .Height TCrop = Width - Height Hcrop = TCrop / 2 End With With .PictureFormat .CropLeft = Hcrop .CropTop = 0 .CropBottom = 0 .CropRight = Hcrop...

Hello, I have searched the internet and these forums pretty extensively trying to come up with an answer to my question. Essentially, I am trying to take an image with an aspect ratio other than 1:1 and crop it to an 8 inch by 8 inch size. I have found that 72 points should correspond to 1...

Hey everyone, Rory helped me last time get the declaration correct for my function but now my colleague wants to maintain aspect ratio and orientation but still have all the pictures the same size.( either legal or landscape orientation) I can maintain original aspect ratio by having -1 for...

I have a form that requires pictures to be placed in it. I have added a button and assigned the following macro to set the size and placement of the picture I need. It works great, except the height does not fit correctly. It seems the height is being controlled by the aspect ratio of the...

Hi Excel Gurus :) I am working on a macro allowing me to insert a picture into a cell activated with a button. I'd like to find out how this could be done. After clicking on a button "Insert Drawing" a generic windows dialog box should pop up asking me to select a picture I'd like to insert...

Hey guys, I've got a workbook that runs on mac and pc. One of the problems with this is that pictures added in one platform lose their aspect ratio when opened on the other. This can be fixed by using the "reset" button in the "format pictures" tab on the ribbon, but I don't know how to do...

Hey guys, I've got a workbook that runs on mac and pc. One of the problems with this is that pictures added in one platform lose their aspect ratio when opened on the other. This can be fixed by using the "reset" button in the "format pictures" tab on the ribbon, but I don't know how to do...

I'm using Excel 2010. I put a TIF file in a header and print it. Then I change the normal font size and print it again. The TIF is squished and squashed depending on the normal font setting. I have not been able to prevent this by any combination of the "lock aspect ratio" or "Relative to...

Hi, I am using the below code to check for existing image (and delete if it exists), and then add an image into a cell range - centred and fit to size (/1.05). This works fine in Excel 2007, but in Excel 2010, the image is being squashed horizontally > < ... any ideas why? Sub...

I have a number of charts in the same workbook. Some of the charts have a different size plot area. Not the chart itself, but the white "pasteboard" that is behind it. Because I ultimately output all of my charts to pdf's and then to gifs (in Photoshop) this change is aspect ratio is messing me...