Hey, I need some help. I am working on a macro to prioritize a list of
job orders by ID and then assign them start dates based on lead time.
In the list there are certain jobs that are not applicable. Is there a
conditional statement or function that I could use to hide any row
that has "n/a" in one of its cells??? Please help! Thanks.

I've just replied to your other post - please do not multi-post.

Pete

On Aug 16, 3:18 pm, wrote:
Hey, I need some help. I am working on a macro to prioritize a list of
job orders by ID and then assign them start dates based on lead time.
In the list there are certain jobs that are not applicable. Is there a
conditional statement or function that I could use to hide any row
that has "n/a" in one of its cells??? Please help! Thanks.

Do you mean the text value "n/a" or the #N/A error and could it be in any
column in the row or a particular column?

Mike

" wrote:

Hey, I need some help. I am working on a macro to prioritize a list of
job orders by ID and then assign them start dates based on lead time.
In the list there are certain jobs that are not applicable. Is there a
conditional statement or function that I could use to hide any row
that has "n/a" in one of its cells??? Please help! Thanks.