Hello All,
I have had great luck getting help from the brilliant members of this forum, so I thought I would try again with a new challenge.
I am trying to resize a picture on a worksheet to fit a dynamic measurement(the size of the page is different depending on the contents in cells).
I am doing this all in VBA.
so what I have come up with is that I need to
1) determine the total column width of only the non-hidden(visible) cells.
2) resize my picture to those measurements, so I can get an exact fit, and it doesn't create a new page break, by going over.
I have found some code on forums, and am thinking of something like this as a solution(although I don't know how to complete it):
For summing column widths:
-or-Please Login or Register to view this content.
Please Login or Register to view this content.
then I would have to use that total column width number as either inches or pixels to resize the width and height to fit on one page of the activesheet.
for that I was thinking of something like this:
Please Login or Register to view this content.
I appreciate everyones help, thank you,
-alex
Bookmarks