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

Hi Rozent,

Try:

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

---
Regards,
Norman


"?????" <@discussions.microsoft.com> wrote in message
news:[email protected]...
>i want to build a macro that will choos defined column or name
> and will filter this column
>
> thank you
> rozent

thank you

"Norman Jones" wrote:

> Hi Rozent,
>
> Try:
>
> '=============>>
> Sub Tester()
> ActiveSheet.AutoFilterMode = False
> 'Range("TEST").AutoFilter
> 'or
> 'Columns(1).AutoFilter
> End Sub
> '<<=============
>
> ---
> Regards,
> Norman
>
>
> "?????" <@discussions.microsoft.com> wrote in message
> news:[email protected]...
> >i want to build a macro that will choos defined column or name
> > and will filter this column
> >
> > thank you
> > rozent
>
>
>