I came across the following macro to resize a picture to fit any cell in Excel. It works great as long as it is not a MERGED cell.
Can anyone tell he how to change it to make it work in merged cells or is that possible???
I don't know who wrote the code, but they did a great job.
Public Sub...