Macro for hiding rows

[Mariesami]

The general format I use for hiding rows is

If Range("G17") = 1 Then
Range("G22:G26").EntireRow.Hidden = True
Else
Range("G22:G26").EntireRow.Hidden = False
End If

In one particular case I want the rows to hide based on an embedded value (that is calculated rather than being entered or selected). This code doesn't work. Is there anything I should add?

 

[patel45]

please upload a sample file with particular case on a sharing site, then paste the link here

 

[Mariesami]

Hi, I'm sorry but I can't really do that now.

I'll try explaining better.
The criteria that I give for hiding the rows is not entered or selected.
For eg:

If Range("G17") = "Yes" Then
Range("G22:G26").EntireRow.Hidden = True
Else
Range("G22:G26").EntireRow.Hidden = False
End If

In the above condition, the 'Yes' criteria is not entered or selected. It depends on a combination of conditions and if the conditions are satisfied the cell G17 shows 'yes'. But the macro doesn't work.

 

[patel45]

The code works on my test wb with formulas