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
But i want to uncheck just the #N/A
@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
No nothings happen
I just want to uncheck the #N/A so that only the numbers will appear on the excel file
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