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