Results 1 to 8 of 8

Variable Print Area Macro Based on Cell Value

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    7

    Variable Print Area Macro Based on Cell Value

    I have a sheet of reference data (A1:I530), and I would like to create a macro that sets the print area for only rows that have a $ total in the H column, and a $ total in the I column. Stated another way, any row that is 0 in H or I columns wouldn't print. I only want this to apply to this individual sheet titled "Cost Codes".

    I think this would be much more economical both for time and paper use than conditional formatting.

    Does anyone have suggestions? Any help is greatly appreciated!


    Thank you
    Attached Files Attached Files
    Last edited by cuclay; 10-26-2009 at 06:07 PM.

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