Thread: can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default can I use a cell content as a Criteria1 reference in the below Sel
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)


Reply With QuoteReply With Quote