+ Reply to Thread
Results 1 to 2 of 2

Print Fixed range plus a selected range.

  1. 08-22-2020, 06:24 PM #1
    zplugger
    zplugger is offline
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Print Fixed range plus a selected range.

    Is it possible to print A1:J1 plus a selected range in middle of a sheet? I always want the first row to print plus any selected range I choose.

    Thanks for any suggestions
    Last edited by zplugger; 08-23-2020 at 05:46 PM.
    Reply With QuoteRegister To Reply
  2. 08-22-2020, 09:01 PM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Print Fixed range plus a selected range.

    Print the top row on every page

    Set the top row to print as the "header" row as outlined in the link above. Then define your print area for the data you want to print.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    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] VBA for Printing to PDF with selected print range based off of a Cell Value
    By Chris McGlothen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2017, 11:57 AM
  2. [SOLVED] Print Selected range number of times with little change
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2015, 11:29 AM
  3. [SOLVED] To print the selected range with page setup
    By muralidaran in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2014, 10:38 AM
  4. Set print area of selected range then print preview if ok then print the document!
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 07:10 AM
  5. [SOLVED] Print Selected Range
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-03-2013, 12:33 PM
  6. set print area from selected range
    By Graham Whitehead in forum Excel General
    Replies: 3
    Last Post: 07-12-2006, 05:10 AM
  7. Macro to print a selected range, not entire worksheet
    By James C in forum Excel General
    Replies: 3
    Last Post: 10-19-2005, 05:12 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