Hide ROW dependent on value
 

Would like to hide one row if its value = the value of a range name.
Came up with the following.
It doesn't return an error, but it doesn't hide the row, even though the
value of Adj Rev is equal to [rangename] Rev.

Cells.Find(What:="Adj Rev").Offset(0, 1).Activate
If ActiveCell.Value = Rev.Value Then
EntireRow.Hidden = True
End If

Any assistance will be greatly appreciated.
Thanx,
- Mike

Hide ROW dependent on value
 

Instead of:
If ActiveCell.Value = Rev.Value Then

try:
If ActiveCell.Value = Range("Rev").Value Then

Hope it works for ya.

Good Luck.

"MikeF" wrote:

Would like to hide one row if its value = the value of a range name.
Came up with the following.
It doesn't return an error, but it doesn't hide the row, even though the
value of Adj Rev is equal to [rangename] Rev.

Cells.Find(What:="Adj Rev").Offset(0, 1).Activate
If ActiveCell.Value = Rev.Value Then
EntireRow.Hidden = True
End If

Any assistance will be greatly appreciated.
Thanx,
- Mike