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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - can I use a cell content as a Criteria1 reference in the below Selection.AutoFilter statement? (https://www.excelbanter.com/excel-programming/368662-can-i-use-cell-content-criteria1-reference-below-selection-autofilter-statement.html)

prady

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)

Tom Ogilvy

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)

All times are GMT +1. The time now is 04:54 PM.