Use Instr to hide or show Rows based on content of cell.

[sorensjp]

Hello,

I'm looking to improve on the code below.

Part 1) I'm using "Instr" to hide or show specific Rows of information. The same cell to determine which Rows to hide so I use "[" or "(" identify the differences. So if either condition is not met then Rows ("11:14","16:18") should be hidden.

Part 2) If the contents from "K7:L7" is cleared I get a "Type Mismatch" error. Which I don't knowhow to get around that.

Please Login or Register  to view this content.

I appreciate anyone reading this and Thank you.

V/r,
Jim

[TMS]

Use

Please Login or Register  to view this content.

at the beginning of your code.

[sorensjp]

TMS,

Thank you for the response. The code does work without If Target.Cells.Count > 1 Then Exit Sub.

My goal were to not have the "Type Mismatch" error if the target cells are cleared. I'm sure my wording is convoluted in Post #1. After all I'm using American English.

V/r,
Jim

[TMS]

When you clear multiple cells, Target is a range (of cells), not a single cell. You can't use Instr on a range; that's why you get the Type Mismatch.

You can use

Please Login or Register  to view this content.

But, clearly, the Target cells will be empty so that is a waste of time. The original solution eliminates the source of the error.

Am I missing something?

[sorensjp]

TMS,

I think your solution works well. I cannot see an issue with the results after running it through some testing.

I appreciate your efforts.

V/r,
Jim

[TMS]

You're welcome. Thanks for the rep.


When I said, "waste of time", I’d missed the Else side of the code ... so I was wrong (but offered the correct solution)