Thread: can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
prady prady is offline
external usenet poster
  
Posts: 1
Default can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement?

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)

Reply With QuoteReply With Quote