Place image in merged cell

[mikeymay]

I have a number of sheets that contain a merged cell (columns only) starting a cell B3 and the number of columns within the merged cell will be different across each sheet.

The row height is 70.

I have an image that needs to be placed in each sheet but in the top right of the merged cell and to fit the height of the merged cell (70).

I have tried to put some code together to establish where the image needs to be placed in a sheet but have failed miserably.......

If someone could help with either pointers or code to do this I would be hugely appreciative!


TIA

 

[jondavis1987]

I don't know about doing it with a formula but if you right click the picture and click on size and properties you can edit it to the size you want. By right click the columns clicking on column width you can find the exact width. The same procedure can be done to rows. Then it's just a matter of moving it into the cell

 

[jondavis1987]

https://www.extendoffice.com/documents/excel/1060-excel-resize-picture-to-fit-cell.html#1

Sorry, didn't realize that didn't work that way but that seems to be what you need