View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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