this is amazing - i mean to say that for the first time i have come to
know about the google group and all this stuff. thanks once again for
your reply i did the same but the result what i want i ma not getting.

i have one macro as follows
Sub HideRows()
Dim Rng As Range
Set Rng = Sheets("Sheet1").Range("B10")
If Rng.Value = "YES" Then
Rows("11:50").EntireRow.Hidden = False
Range("B11").Select
ElseIf Rng.Value = "NO" Then
Rows("11:50").EntireRow.Hidden = True
Range("B51").Select
End If
End Sub


now this macro i want to assign to YEs or NO. when i pasted the code
that you have given, i got a result of No or Yes instead of hiding or
unhiding of the rows.

ealrier i used to think that i know a lot about excel but now i am
realising that i know nothing , even though i am a finance guy. i hope
you would be able to sort my tiny problem