+ Reply to Thread
Results 1 to 6 of 6

Pdf print excel range error

  1. 05-16-2020, 10:17 PM #1
    technik
    technik is offline
    Forum Contributor
    Join Date
    04-19-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    180

    Pdf print excel range error

    Hi

    Even though I am using the code below which (should) sets to print my pdf range onto one PDF page, I am getting the range being printed out on 80 different pages. Why? 

    Please Login or Register  to view this content.
    Can anyone help? I need this range on one page landscape. Many thanks.
    Reply With QuoteRegister To Reply
  2. 05-16-2020, 10:45 PM #2
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Pdf print excel range error

    Possibly... 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 05-16-2020, 10:54 PM #3
    technik
    technik is offline
    Forum Contributor
    Join Date
    04-19-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Pdf print excel range error

    Thanks Dangelor .. that works a lot better.

    Is it possible to have the margins narrow as it's leaving a BIG border all the way around?
    Last edited by technik; 05-16-2020 at 10:57 PM.
    Reply With QuoteRegister To Reply
  4. 05-16-2020, 11:02 PM #4
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Pdf print excel range error

    It's printing almost 10,000 cells on one page. How big did you think it would be?
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 05-16-2020, 11:04 PM #5
    technik
    technik is offline
    Forum Contributor
    Join Date
    04-19-2010
    Location
    Manchester
    MS-Off Ver
    Excel 2007
    Posts
    180

    Re: Pdf print excel range error

    Yes sorry I changed the range as I was using a different worksheet. Couldn't edit the post fast enough
    Reply With QuoteRegister To Reply
  6. 05-17-2020, 06:27 AM #6
    dangelor
    dangelor is offline
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Pdf print excel range error 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Location to print array not find error 9 out of range
    By incobart in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-27-2017, 02:52 AM
  2. Find Print Range and Print invoices from 250 tabs in Excel
    By Mr5holesinone in forum Excel General
    Replies: 4
    Last Post: 02-24-2014, 08:19 PM
  3. VBA problem with Print Range code run-time error 1004 text not valid reference
    By Jeep56 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-14-2013, 03:38 PM
  4. VBA to set print range, open box asking for print qty, print, then redefine print area
    By galvinpaddy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2012, 06:43 PM
  5. Excel 2010 print/print preview error for combo boxes
    By dlmcdan in forum Excel General
    Replies: 3
    Last Post: 03-23-2011, 12:32 PM
  6. Error in Macro to print a Range
    By tariqnaz2005 in forum Excel General
    Replies: 7
    Last Post: 11-11-2009, 11:09 AM
  7. Why do I get a print error light trying to print an excel sheet ?
    By SMC in forum Excel General
    Replies: 2
    Last Post: 11-04-2005, 09:40 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1