Macro Help

[tbourne]

Hey Guys,

I need help hiding rows based on a cells value....

I need cells 14 - 47 hidden until the button that you create has been pressed.
once the button has been pressed I need the following to happen:
Show Rows 19:23 and 29:33 when the button is pressed (regardless of the value)
If Cell "I1" is OR greater then 2 show rows 14:18 and
If Cell "I1 is or greater than 22 days then show rows 24:28
If Cell "I1" is or greater than 15 days show rows 34:46

 

[villy]

Try:

Sub hid()
Rows("14:47").Hidden = True
Rows("19:23").Hidden = False
Rows("29:33").Hidden = False
Select Case Range("I1").Value
    Case Is >= 15
        Rows("34:46").Hidden = False
    Case Is >= 22
        Rows("24:28").Hidden = False
    Case Is >= 2
        Rows("14:18").Hidden = False
End Select
End Sub

 

[AlphaFrog]

    Case Is >= 15
        Rows("34:46").Hidden = False
    Case Is >= 22
        Rows("24:28").Hidden = False
    Case Is >= 2
        Rows("14:18").Hidden = False

The CASE order need to be changed. You need to test >=22 before you test if >= 15 otherwise the second Case ( >=22) will never get selected because all values that are greater than 22 are also greater than 15. So the first case (>=15) will evaluate true before the second case has a chance to evaluate.

The case order should be switched to this...

    Case Is >= 22
        Rows("24:28").Hidden = False
    Case Is >= 15
        Rows("34:46").Hidden = False
    Case Is >= 2
        Rows("14:18").Hidden = False

 

[villy]

Thanks Alpha I noticed that you're just too quick to post..hehehe
cheers