I'm trying to a cell height and Width based on the combined total of a Range of Cells.
Example here, I am trying to add up the height and width of the cells I3 to O9. And then set a cell height width on another sheet that equals that combined height and width.
I'm close with the below, but can't figure out the conversion from the pixels to compute it correctly
Please Login or Register to view this content.
Use the Left of the Column adjacent to the right and subtract the Left of the leftmost column.
Same for the Rows
Experience trumps academics every day of the week and twice on Sunday.
Let the computer do the calculating.
Change the references as required.Please Login or Register to view this content.
Last edited by jolivanes; 09-26-2022 at 02:59 PM. Reason: Added info
That's perfect!!
Thanks!!
Thanks for the update.
Good Luck
This might be easier to adapt for different scenarios.
Again, change references as required.
It'll only gives the right result if all columns within the range are the same width. Same for the rows.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks