VBA to Hide Rows

[excel_dn]

Hi Guys,

I'm looking for a VBA that will hide rows when two conditions are met.

In column O I have a numeric value which, for a row to be hidden needs to be less than 0.

In column P I have either Yes/No. When it is No I want the row to be hidden.

Therefore when O = <0 AND P = No then row will be hidden.

TIA

 

[Joe4]

A few things to check:

Are the entries in column O numeric (numbers), or are they text entered as numbers?
One way to check is to identify a cell that meets your condition, and enter this formula into any blank cell and see what it returns.
(let's say it is cell O4):

=ISNUMBER(O4)

If that returns TRUE, then check this formula:

=O4<0

Also note. In your original question, you said <=0, but in your code, you were using <0.
So which one is it that you really need?

The second thing to check is to see if column P is EXACTLY equal to "No". Is it always written like that, or might it also be "NO" or "no"?
Also make sure tha there are no extra spaces at the end of it.
Just like above, find an entry in column that meets your condition, and enter this formula in a blank cell and see what it returns.
(let's say it is cell P4):
=P4="No"

Lastly, make sure BOTH those conditions are met on the same row, for the row to be hidden.

 

[excel_dn]

I can confirm that in Col O it is numeric numbers and in Col P it is text.

In Col P if a cell says No it will always appear as "No"

I need it to be LESS THAN zero which is why I took out the "="

 

[Joe4]

Did you run all those tests that I gave you, and confirmed each formula returned TRUE?

Also, do you have any blanks in column A in your data? Because the macro will stop at the first blank it finds in column A.

If neither of those is the issue, please post a sample of your data. You can do that using the tool mentioned here: XL2BB - Excel Range to BBCode

 

[excel_dn]

Hi,

I had blanks, got rid of them, thanks so much it works now!

 

[Joe4]

I had blanks, got rid of them, thanks so much it works now!

Excellent! Glad to hear it!

Note that you can also alter that check to look at a different column, if it is more reliable to use a column other than A to find identify which rows to run against.