1 Like
How to unselect the #N/A
Have you selected Use filter option in Read Range Activity ?
If yes then uncheck and try then it will ignore filter and will read all the data.
Hi
It can be done once after getting the datatable
That is using excel application scope and read range activity we can get the datatable output named dt
And to filter all records without N/A value then this thread would help you
Cheers @Carla_Marie_Barte
The Use filter is uncheck
1 Like
Then it should read whole data.
But i want to uncheck just the #N/A
Then this would help us
@Carla_Marie_Barte I guess We just need to use Filter Datatable Activity and use Filter Operation as Does Not Contain ‘#N/A’. 
I used that at first but it doesn’t work
oh 
@Carla_Marie_Barte What was the Result, It didnt Filter at All, or did it Filter some rows?
No nothings happen
I just want to uncheck the #N/A so that only the numbers will appear on the excel file
@Carla_Marie_Barte Can you tell us What are the Operations that you are performing currently
?
Use invoke vba for unselect #N/A
Sub Macro1()
’
’ Macro1 Macro
’’
Columns(“B:B”).Select
Selection.AutoFilter
ActiveSheet.Range(“$A$1:$A$13”).AutoFilter Field:=1, Criteria1:=“<>#N/A”, Operator:=xlFilterValues
End Sub
choose your range accordingly by passing variables
@Carla_Marie_Barte Filter Datatable Will Just Filter the Datatable. It will not effect the Excel File
I think you need to use Filter Table instead of Filter Datatable if you want the Expected Output
dont do it
Anil_G
ashokkarale
Andreea_Nistor
jmsphlp
jeevith
Nissy_Ruth_Prabhu
CHEN-CC
stary
SorenB
sharazkm32