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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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,525
Messages
6,125,325
Members
449,218
Latest member
Excel Master

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