can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement?

[prady]

Hi..I am new to this group. I am self learing how to code macros. Here
is my question

can I use a cell content as a Criteria1 reference in the below
Selection.AutoFilter statement?

Selection.AutoFilter
Selection.AutoFilter Field:=29, Criteria1:=Cells(29, 2)

[Tom Ogilvy]

Yes

--
Regards,
Tom Ogilvy


"prady" wrote:

>
> Hi..I am new to this group. I am self learing how to code macros. Here
> is my question
>
> can I use a cell content as a Criteria1 reference in the below
> Selection.AutoFilter statement?
>
> Selection.AutoFilter
> Selection.AutoFilter Field:=29, Criteria1:=Cells(29, 2)
>
>