I am trying to work on a worksheet change event.
Here is what i got
Set rng = Range("F37")
Range("A21" & numRows":A30").Select
Selection.EntireRow.Hidden = True
What I want is that every time the value of cell f37 changes I want to hide the rows that are in the range.
Cell f37 will always have a number in it from 0-10
The range I want to hide is A21:A30.
If the vaule in F37 is 0, I want to hide A21:A30
If the value in F37 is 1, I want to hide A22:A30
If the value in F37 is 2, I want to hide A23:A30
and so on so that
If the value in F37 is 9, I want to hide A430:a30
If the value in F37 is 10, I won't want to hide any rows
Any suggestions on how to do it.
Mark
Here is what i got
Set rng = Range("F37")
Range("A21" & numRows":A30").Select
Selection.EntireRow.Hidden = True
What I want is that every time the value of cell f37 changes I want to hide the rows that are in the range.
Cell f37 will always have a number in it from 0-10
The range I want to hide is A21:A30.
If the vaule in F37 is 0, I want to hide A21:A30
If the value in F37 is 1, I want to hide A22:A30
If the value in F37 is 2, I want to hide A23:A30
and so on so that
If the value in F37 is 9, I want to hide A430:a30
If the value in F37 is 10, I won't want to hide any rows
Any suggestions on how to do it.
Mark