Read range inside application scope with using filters fails

Help
,
33

I’m facing the same issue. For me however the Read Range was working well till last week, on the same file. I used a Parseexact to get date from another file, and that was the only change I did in the code and since then I’m facing this issue. I tried both Scope read range and Workbook read range. Both gives me errors, different though. Please see below the error messages.

Application scope Read Range
Scope

Workbook Read Range
Workbook

As @Iruths mentioned I’m getting some cells as ##### in the excel. When I tried to read the range which doesn’t have the # symbol, it worked.

As this was working perfectly I’m not sure what could have gone wrong. Will changing the Culture format solve the issue? I tried to changing to few formats, but it’s the same.