Results 1 to 9 of 9

Code to print columns with active rows not working

Threaded View

  1. #1
    Registered User
    Join Date
    06-08-2009
    Location
    Annapolis, Maryland
    MS-Off Ver
    Excel 2007
    Posts
    85

    Code to print columns with active rows not working

    Hello again! I have a code that will print all active rows on a spreadsheet, however I'm looking for something that will print certain columns when selected. Example:

    Columns A - N contain data for seven departments.
    I want to print columns B - D and then column F for one department; B - D with column G for another, etc. In other words, columns B - D will always be included with each department's column when it's printed.

    Is there a way a button could be placed over each department's column (say, columns G thru M) that will allow that to happen...and keep my macro to print only active rows? If so, please point me in the right direction; my searches have produced dead ends. Thanks!!
    Last edited by debbiesh; 07-09-2009 at 08:09 AM.

Thread Information

Users Browsing this Thread

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

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