+ Reply to Thread
Results 1 to 2 of 2

VBA Macro to hide row if 4 cells are > a value

  1. #1
    Registered User
    Join Date
    03-29-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2010
    Posts
    1

    VBA Macro to hide row if 4 cells are > a value

    Hi all, Ive been trying to work on a bit of code to hide an entire row if 4 cells are each above a certain value

    Everything I've tried has either not worked or crashed Excel!

    Here's a sample:
    Kyocera Mita CLP 3316_CLP 4316 192.168.0.29 Sleeping 75% 25% 100% 63%
    Kyocera Mita CDC 1726_DCC 2726 192.168.0.212 Ready. 11% 92% 99% 71%
    Kyocera Mita CDC 1726_DCC 2726 192.168.0.250 Ready. 61% 85% 86% 60%
    UTAX Utax CLP 3630 192.168.4.189 Ready 40% 55% 70% 56%
    UTAX Utax CDC 1725 192.168.4.171 Ready 22% 93% 11% 99%

    It's the last 4 cells in each row I'm concerned with - if none of them are under 25%, I want the row hidden completely.

    Any ideas!?

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: VBA Macro to hide row if 4 cells are > a value

    Please Login or Register  to view this content.

+ 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