+ Reply to Thread
Results 1 to 2 of 2

Set page break around image inserted

  1. #1
    Registered User
    Join Date
    08-21-2013
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    44

    Set page break around image inserted

    I am having no luck with trying to find a VBA code that will auto set my page break around an image I inserted. Is there a way to do this even? Furthermore, there is a possibility of inserting multiple images in which I would need each image put on a different page and have the macro set the page break around each image. So if I inserted two images then I would need the macro to set two pages and break each page around the image size? Any Help?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Set page break around image inserted

    You can add the height of the picture to the print area. Can you post your code??
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. [SOLVED] button erase dont erase an image inserted on an image control
    By Nuno Neves in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 08:04 AM
  2. Find First match value and add page break, findnext value and add page break
    By dwx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2013, 12:58 PM
  3. Add Page Break After Pasting Image
    By scrumbag in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-25-2010, 10:03 AM
  4. need page break by asking the input file for page break to be done
    By saikumar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-10-2008, 07:33 AM
  5. adding a new page break to an existing page break
    By Edward Letendre in forum Excel General
    Replies: 1
    Last Post: 03-06-2005, 06:06 AM

Tags for this Thread

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