How could I express a statement like; If autofilter=on then...? what is the value for autofilter?
C Confused Individual Feb 18, 2004 #1 How could I express a statement like; If autofilter=on then...? what is the value for autofilter?
B Bernie Deitrick Feb 18, 2004 #2 Confused, If ActiveSheet.FilterMode Then Note that ActiveSheet.FilterMode is only True if the Filters have been applied and are actually hiding some values in the table. HTH, Bernie MS Excel MVP
Confused, If ActiveSheet.FilterMode Then Note that ActiveSheet.FilterMode is only True if the Filters have been applied and are actually hiding some values in the table. HTH, Bernie MS Excel MVP
