+ Reply to Thread
Results 1 to 3 of 3

Code to not print row if cell equals "x"

  1. #1
    Registered User
    Join Date
    02-15-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Code to not print row if cell equals "x"

    Hi, I have a budget spreadsheet where Column C says "type in amount here". When a user prints the final budget I want it to not print the rows where the "type in amount here" remains, ie just print the rows with actual amounts (and other info, obviously).

    I assumed this would be easy but I can't find any code for it.

    Thanks

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Code to not print row if cell equals "x"

    Autofilter: http://www.contextures.com/xlautofilter01.html
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    02-15-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Code to not print row if cell equals "x"

    Thanks, but the sheet is protected, and downloadable by the public, so there is no way of knowing a user's expertise level, and there is extra info at the top of the sheet so can't be filtered. The print area is set (one A4 page only) so it's just a matter of printing out a sheet that looks sensible.

    I've attached a PDF of the sheet in question. What I'm really trying to do is have the sheet not print any rows that have "<< copied from Income In-kind" in Column C, or, at least, not print that actual phrase - it actually doesn't matter if blank cells are printed, in fact thining about it that's probably preferable as it would show no in-kind amounts rather that no printed rows. Those expenditure cells get populated when amounts are entered into the In-kind Income column.

    This is the first sheet I've ever used with VBA so wading through mud.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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