Home > Software engineering >  How to use VB to realize extraction of EXCEL one column of "# N/A" value
How to use VB to realize extraction of EXCEL one column of "# N/A" value

Time:10-23

Please can help me write statement, thank you!
Why the right
Sheets (" neighbourhood relations (vertical) "). Select
Rows (" 1 "). Select
Selection. The AutoFilter
ActiveSheet. Range (" $A $1, $C $130759 "). The AutoFilter Field:=3, Criteria1:="# N/A"
And this is not correct, the only confirmed is
Why change to: not right?
Criteria1: & lt;>" # N/A"
  • Related