Results 1 to 7 of 7

Check two cells within a row and potentially hide the row

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Question Check two cells within a row and potentially hide the row

    I would like to thank you in advance for any help you can provide. I'm new to trying to write code for an excel macro from scratch. I usually record them then tweak.

    I need to build a macro that will check the value of two cells within the same row to make sure they are 0 (zero). If they are both 0 I need the row to be hidden. This needs to be done for a static number of rows.

    Basically: If cell Q41 = 0 AND AC41 = 0 then hide the row. Continue this until row 78, for the given columns, then stop.

    Please let me know if I need to provide more information. Any help is greatly appreciated.

    Regards,

    Craig K.
    Last edited by Craig K.; 10-11-2012 at 03:14 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