Resize picture to fit merged cell

I would prefer for the code to recognize pictures inserted anywhere on the worksheet. Also, it is now working to some extent once the picture is inside the boundaries of the cell. The new problem is that it resizes based on a single cell and not the range of merged cells. Appreciate your help again!

Richard,
I've attached a worksheet where the pictures would be located. As you can see the current code resizes it to fit only B46, but the worksheet I use would require merged columns at the least.