Help writing a macro to filter

[Texcel]

I am trying to write a macro that will filter based on a certain criteria. I know how to record the basic macro, but my criteria is not as simple. I want to display all rows where column C is an error (i.e. #DIV/0!, #N/A). How do I get the filter to recognize column C is a error?

 

[Corticus]

Welcome!

ISNA() will return a Boolean for NA#

To avoid div/0, use an if() to test for the divisor = 0.

HTH,
Corticus
This message was edited by Corticus on 2002-10-16 16:39

 

[Texcel]

Thanks for the help!

 

[Mark W.]

On 2002-10-16 16:04, Texcel wrote:
I am trying to write a macro that will filter based on a certain criteria. I know how to record the basic macro, but my criteria is not as simple. I want to display all rows where column C is an error (i.e. #DIV/0!, #N/A). How do I get the filter to recognize column C is a error?

The ISERROR worksheet function will return TRUE if its referenced value is any error type (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!). You may also want to examine the Excel Help topic for "ERROR.TYPE worksheet function" if you want to discriminate between these errors.