My end goal is to center an image in a merged range. I found code that will allow me to center an image in a cell but I cant seem to figure out how to (or even if its possible to) modify it to work on a merged range instead of a single cell.
If anyone has any idea about how to modify this code, or a different way all together to go about this any help would be much appreciated!
In the attached file ctrl+w will center an object in the selected cell provided that the top right corner of the object is located in that cell.
Bookmarks