in macro have code:
01=Range("a3").value


cell a3 is in worksheet & can contain word "Product:" or a number like 4

what code can I use to use what is captured in 01 above in a line of macro
code such as:

selection,autofilter filter = (value of 01)

I am trying to run an autofilter from fields located in worksheet.
thanks
rleonard

selection,autofilter filter = 01


"Robert E. Leonard Sr" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> in macro have code:
> 01=Range("a3").value
>
>
> cell a3 is in worksheet & can contain word "Product:" or a number like 4
>
> what code can I use to use what is captured in 01 above in a line of macro
> code such as:
>
> selection,autofilter filter = (value of 01)
>
> I am trying to run an autofilter from fields located in worksheet.
> thanks
> rleonard
>
>

selection.autofilter Field:=1, Criteria1:= 01

or maybe

selection.autofilter Field:=1, Criteria1:= """ & 01 & """

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Robert E. Leonard Sr" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> in macro have code:
> 01=Range("a3").value
>
>
> cell a3 is in worksheet & can contain word "Product:" or a number like 4
>
> what code can I use to use what is captured in 01 above in a line of macro
> code such as:
>
> selection,autofilter filter = (value of 01)
>
> I am trying to run an autofilter from fields located in worksheet.
> thanks
> rleonard
>
>