Hi there ladies and gents,
I have a tab in my workbook which stores various images.
Each of these images will have a height of 300 points, with the width scaling automatically.
The only columns on this sheet that are visible are columns A and B - I'd rather keep it that way.
However, obviously excel can get a bit funny if you try to shift shapes off the sheet. Therefore, before inserting the image I have to ensure that the width of Column A + width of column B does not exceed the width of the photo - and it it does, to adjust the width of column B.
Furthermore, once this is done, none of the other images will be in the center - so I'd want it to loop through each of the images and adjust the Shape.Left property to reposition it
Adjusting the positioning of each image works out beautifully. However, I can't seem to get the bit which adjusts column widths working.
Here's the code I've got:
I assume it's because column width can't exceed 255 characters and when I demand a column width of 373 for example it's trying to do that in characters instead of points.
I hope this kind of makes sense. Any suggestions?
Thanks,
Lady Marmalade
Bookmarks