1. Try this perhaps?

If ActiveSheet.FilterMode Then

MsgBox "Filter is off"

Else

MsgBox "Filter is on"

End If

2. "is there a resource where you can search for excel vba functions"

Obviously you can search the Help Files for the Built in Functions.

You can search Google for: Excel User Defined Functions

To see other functions created for Excel.

Also remember that all and Add-in is, is a collection of user defined functions.

A lot od them provide the source code for free.

So Google: Excel Addin source code

... as well

;-)

JeffCoachman

JeffCoachman

If ActiveSheet.FilterMode Then

MsgBox "Filter is off"

Else

MsgBox "Filter is on"

End If

2. "is there a resource where you can search for excel vba functions"

Obviously you can search the Help Files for the Built in Functions.

You can search Google for: Excel User Defined Functions

To see other functions created for Excel.

Also remember that all and Add-in is, is a collection of user defined functions.

A lot od them provide the source code for free.

So Google: Excel Addin source code

... as well

;-)

JeffCoachman

JeffCoachman