+ Reply to Thread
Results 1 to 3 of 3

Using a Macro to define a print area and send to default printer

  1. #1
    Registered User
    Join Date
    02-06-2014
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Using a Macro to define a print area and send to default printer

    Hi, I am new the forum and a novice at Excel Macros and viertually no VBA experience.
    I was hoping someone could help me get started with a specific task I am working on.
    I want to create a button on an existing Excel sheet that defines a print area and sends to the default printer.
    This would include columns a-l and rows 1-x. Row X being the last row that has an data in column A.
    I don't even know how to create the associated button for this Macro...assuming a macro can be written to accomplish this task.

    Any help or examples are appreciated.

    Thank you,

    Tad

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,526

    Re: Using a Macro to define a print area and send to default printer

    Try this
    Please Login or Register  to view this content.
    Change PrintPreview to PrintOut

    You may have to use the macro recorder if it doesn't automatically use your default printer.

  3. #3
    Registered User
    Join Date
    02-06-2014
    Location
    MN
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Using a Macro to define a print area and send to default printer

    This worked perfectly! Thank you very much for your help.

    Tad

+ 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] Macro to print to the default printer
    By Alves76 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-22-2013, 05:47 AM
  2. Adjust existing macro to print to default printer
    By Sanceus in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2012, 10:32 AM
  3. macro to print 2 copies to default printer, then 1 copy to Adobe PDF printer
    By jwright650 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-26-2011, 01:07 PM
  4. tweeking macro to print to specific printer (non default)
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-20-2010, 11:23 AM
  5. macro print to default printer help
    By st24rsap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-16-2009, 07:22 AM

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