+ Reply to Thread
Results 1 to 2 of 2

Centre an existing picture over multiple columns

  1. #1
    Forum Contributor
    Join Date
    01-14-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    109

    Centre an existing picture over multiple columns

    Good day

    I tried multiple macros but not winning.
    Most of the macros want to insert the picture and only center it in one column and row.

    I have Sheet1 with a Picture (Picture 7) in B4
    I need a macro that would center and not resize the picture over B4,C4,D4,and E4 as the sizes of these keeps on being amended. I also tried to merge these cells and center but it only centers on B4

    Picture 7 needs to center over these 4 columns irrespective their size.
    Would appreciate help please.
    Last edited by 6StringJazzer; 10-31-2023 at 08:13 AM. Reason: Edited title, even though in fact the picture may be exciting.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,481

    Re: Centre an existing picture over multiple columns

    Hi there,

    See if the following code does what you need:

    Please Login or Register  to view this content.
    The highlighted values may be altered to suit your requirements.


    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. centre across selection while hiding columns
    By Littlesimon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-28-2021, 08:46 PM
  2. Hello to a very exciting group of people
    By neetal in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-30-2014, 07:27 PM
  3. [SOLVED] sizing picture same picture in multiple sheets macro clean up
    By martinez77 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-12-2013, 10:14 PM
  4. Insertion of picture by xls formula/ naming the picture with multiple selection crite
    By luckiest man in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2011, 12:11 AM
  5. How do I Centre Align an Overlaying Picture on a Cell? Not Manually!
    By e4excel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2011, 10:00 AM
  6. modify code to always centre the picture
    By beatrice25 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-06-2008, 10:03 AM
  7. Replies: 5
    Last Post: 03-16-2006, 08:24 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1