+ Reply to Thread
Results 1 to 5 of 5

Macro to print specific cells

  1. #1
    Registered User
    Join Date
    02-12-2010
    Location
    Toms River, NJ
    MS-Off Ver
    Excel 2010
    Posts
    42

    Macro to print specific cells

    I need a macro to print the following

    Row 1 cells b:c,d,e,f,g,h,k,l

    And then for every row with a number in column C print cell A b c f g n and other

    How can I do this?

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Macro to print specific cells

    Hello MannyLNJ,

    Do you want to print these rows on a single sheet with no gaps between them to the printer?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-12-2010
    Location
    Toms River, NJ
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Macro to print specific cells

    Yes I want the first page to have the Agent name, Id the date, and total of calls.
    Then for each call I need the # of the claim. the Social Sec #, Que Type and then if the call was lost the time the call ended



    Capture.JPG
    Attached Files Attached Files

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259

    Re: Macro to print specific cells

    Hello MannyLNJ,

    Did you want the call information on the first sheet also or just the header?

  5. #5
    Registered User
    Join Date
    02-12-2010
    Location
    Toms River, NJ
    MS-Off Ver
    Excel 2010
    Posts
    42

    Re: Macro to print specific cells

    Quote Originally Posted by Leith Ross View Post
    Hello MannyLNJ,

    Did you want the call information on the first sheet also or just the header?
    Call info on each sheet. I think 30 calls can fit on one sheet.

+ 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. macro to print a specific range of cells
    By shortnewb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2018, 10:05 AM
  2. [SOLVED] Macro to copy specific data from one WB to specific cells in another WB based on specific
    By d_rose in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-26-2014, 11:05 AM
  3. [SOLVED] Print Macro to email PDFs of specific pages of a workbook to specific recipients
    By mike_vr in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 12:34 PM
  4. Print specific pages based on specific cells
    By cane corso in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-30-2008, 05:23 PM
  5. [SOLVED] Macro to Print specific cells with formatting
    By Clark in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2006, 03:15 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