ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Filling both hidden and visible cells once a filter has been applied (https://www.excelbanter.com/excel-programming/380180-filling-both-hidden-visible-cells-once-filter-has-been-applied.html)

Corrie

Filling both hidden and visible cells once a filter has been applied
 
I am very new to VBA. So my apologizes first for ignorance if this is
an easy problem to address.

I am trying to fill a column with different data ("incorrect" and
"correct") based on filtered criteria. Example:

Sheets("L-G DL").Select
Rows("1:1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=14, Criteria1:="-100", Operator:=xlOr,
_
Criteria2:="<100"
Selection.AutoFilter Field:=11, Criteria1:="10", Operator:=xlAnd
Selection.AutoFilter Field:=12, Criteria1:="10", Operator:=xlAnd

Once the columns have been filtered I would like to fill the visible
cells (but not the header) in column 21 with the word "correct" and
hidden cells with "incorrect".

Once this is done I will use the new information in a pivot table. I
can't seem to come up with a way to do this. Does anyone have an
approach that may work?



All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com