hide rows based on two columns

[ABDELFATTA]

hi
i have this code but if on of them value is 0 then hide rows but what i want if in col b,c =0 then hide so if on of them 0 and another not 0 it shouldn't hide rows

[Fluff13]

How about

Please Login or Register  to view this content.

[sintek]

hide rows based on two columns

Am I missing something...None of the above code is actually doing this...False TO True Perhaps

[Fluff13]

Oops, didn't look at that bit of the code, it should indeed be True not False

[ABDELFATTA]

hi, fluff and sintek you're right about true not false i changed to false to show rows and change to true to test my code
for code fluff you misunderstood i want if col b and c together are 0 it still hide row if one of them =0 not together=0

[Fluff13]

Do you have real numbers in both columns, or numbers stored as text?

[ABDELFATTA]

numbers not text

[Fluff13]

In that case after swithching the False to True, the code in post#2 works.
Unless you have blank cells which will be treated as 0

[ABDELFATTA]

it doesn't work as i want this is my file it supposses hide only row2,3 but it hide also row4 you can check it

[Fluff13]

That's because you are not using the code I supplied.

[ABDELFATTA]

sorry about change range (b2: c250) not your code i though not work that's why i changed now the code really works
thanks so much

[Fluff13]

You're welcome & thanks for the feedback.

[ABDELFATTA]

hi fluff , is there any way to do more fast that without loop? because if i have empty rows the code passes on them and it takes time

[sintek]

If there are blank cells within the range...Try

Please Login or Register  to view this content.

Or if there are blank rows from a specific cell to end then just reduce the range to include lastrow...
Or use filter if you have a big dataset...

[ABDELFATTA]

thanks sintek this is better

[sintek]

Glad I could assist...tx for unexpected rep +