autofilter macro in excel2000
 

i want to build a macro that will choos defined column or name
and will filter this column

thank you
rozent

autofilter macro in excel2000
 

Hi Rozent,

Try:

'=============
Sub Tester()
ActiveSheet.AutoFilterMode = False
'Range("TEST").AutoFilter
'or
'Columns(1).AutoFilter
End Sub
'<<=============

---
Regards,
Norman


"?????" wrote in message
...
i want to build a macro that will choos defined column or name
and will filter this column

thank you
rozent

autofilter macro in excel2000
 

thank you

"Norman Jones" wrote:

Hi Rozent,

Try:

'=============
Sub Tester()
ActiveSheet.AutoFilterMode = False
'Range("TEST").AutoFilter
'or
'Columns(1).AutoFilter
End Sub
'<<=============

---
Regards,
Norman


"?????" wrote in message
...
i want to build a macro that will choos defined column or name
and will filter this column

thank you
rozent