Hide rows when two cells are blank

Hi all!

I want to hide an entire row, if cell in column B and Column C is blank. I m using the below code but getting an error type Mismatch 13 and highlighting the

Please Login or Register  to view this content.

.

My Data Starts at 190 and ends at 325; hence I am named that range as "Remarks1"

Column C contains formulas.

I am using the below code:

Please Login or Register  to view this content.

you have defined lr as Long but you have set it equal to a range. That is why you get the error

I have changed now to

Please Login or Register  to view this content.

Still an error satying Run-time error: 91

Object Variable or With Block Variable not set.

You can use

Please Login or Register  to view this content.

to get the last row in that named range where lr is still defined as long (or integer).

You cannot use it as a range because For i = .. To... requires 2 integers.

Still error persits

Using

Please Login or Register  to view this content.

With lr as Long, I am getting Type Mis-match and highlighting

Please Login or Register  to view this content.

With lr as Range, I am getting Object Variable or With Block Variable not set and highlighting

Please Login or Register  to view this content.

Thank Arkadi.

That helped.