Whenever I try to write a macro for making a range in excel the dimensions as a selected object in powerpoint, they are not the same when pasting the range in excel as a picture in powerpoint. Anyone know a macro that will do this?
I want to create an excel macro that resizes a selected range of cells in excel to match the height and width of a selected object in powerpoint. I want it to change regardless of monitors being used or DPI settings and make it so that if I copy the range of cells in excel and paste it as a picture in powerpoint than it is the exact same dimensions as the original shape I had selected in powerpoint.
Jake Silverthorn is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.