Centering images in a range of cells

Casin0Tech

New Member
Joined
Jan 19, 2022
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Is there a way to center an image within a range of cells? Im working on a form for work and i would like to have the logo centered in the middle of the page within the range of A1 and K5. Ive tried to use the VBA modules for centering an image within a cell but i am not familiar with using those and havent had any luck with altering the code to cover the range i need. If someone could explain how to use a range in those modules or have a module that can help me out i would really appreciate it!
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
A1 and K5
left of logo = (left of A1 + left of L5 - width of logo)/2
top of logo = (top of A1 + top of A6 - height of logo)/2
So what is the name of your logo (= the name of the shape with your logo)
 
Upvote 0

Forum statistics

Threads
1,215,045
Messages
6,122,840
Members
449,096
Latest member
Erald

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
Back
Top