nevermind - it's working for me now as well. thanks again for the help.

"JE McGimpsey" wrote:

What error do you get - your line of code works fine for me.

In article ,
pls wrote:

Thanks! if i have additional conditions i want to add, how do i add that to
the code? for example, i tried to add the following before the End Sub, and
got an error:

Range("7:10").EntireRow.Hidden = (LCase(Range("D6")) = "new client")