Results 1 to 2 of 2

hide/unhide rows based on reference to cell that contains a formula result (vlookup)

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    mpls mn
    MS-Off Ver
    Excel 2007
    Posts
    15

    hide/unhide rows based on reference to cell that contains a formula result (vlookup)

    I the attached example, I want to use VB to hide or unhide rows 16-17 based on the result of a formula in cell O8; if it is not possible to reference the result of a formula versus a value, the I could reference cell A3 (which contains values that change) but I would want to specify that if A3 = 1, 2, 6, 7, 12, ...(~35 total discrete values) then rows 16-17 should display and otherwise should be hidden. Any help is very much appreciated.
    Attached Files Attached Files

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