Filter Data Table Column Not Found

Help
1

I am getting an error while trying to filter a data table that doesn’t have a header row. I have it defined in the filter as dtTemp.Columns(5) but I am getting an error cannot find Column 5.

Should I be using different syntax for this? Thanks

2

Hi Chris, if you can share some screenshots of dtTemp rows and filtering activities(i mean your workflow) maybe i can help you.

3

Hi @Chris_Livesay

Your Syntax is absolutely right …
Note that In excel sheet columns are starts with 0 index (i.e Columns(0)–First column Columns(1) --Second column and vice versa)
so I thing you count from index 1 at starting
so check with this dtTemp.Columns(4)

If you find it useful mark it as solution and close the thread.

Thank You
Regards
Gulshiyaa