Place image in merged cell

mikeymay

Well-known Member
Joined
Jan 17, 2006
Messages
1,489
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
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

jondavis1987

Active Member
Joined
Dec 31, 2015
Messages
416
Office Version
  1. 2019
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,133,524
Messages
5,659,315
Members
418,496
Latest member
WHYCHumphrey

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top