I would like a macro that returns the width and height of an excel chart copied as a picture to the clipboard.

The reason I want to do this is that I want to paste pictures into textboxes in Word and ensure consistency of appearance. So, I’ll set the width of each textbox to a full text column width, adjust the pasted picture’s width to slightly less than the width of the box (maintaining aspect ratio so it doesn’t distort), then set the height of the textbox to a little bit more than the new height of the picture inside it.

So, in order to set the textbox’s size I’d like to know the dimensions of the picture to go inside it before it’s pasted.

Apologies if this looks more like a Word than Excel question