(Solved) – Filter blank cell value

  • by
(solved)-–-filter-blank-cell-value

I am trying to filter the columns which is not blank, however it doesn’t work with following code:

 ActiveSheet.Range("A:FE").AutoFilter Field:=12, Criteria1:="<>", Operator:=xlOr

Also please notice that there are 6 rows on top of the header and I can’t delete it for other purpose

I don’t know will it affect the coding

Leave a Reply

Your email address will not be published. Required fields are marked *