Delete the row if column has "0"


I am trying to delete the whole row of an excel sheet if column H has “0”. But getting the following error: Collection was modified; enumeration operation might not execute.
I have attached the file. Could anyone help

Pilot_Refresh_MB5B_MB5T.xaml (10.2 KB)

hi @nikhilaramesh08,

use assign activiy"[Total Receipt Qties] <> '0'").CopyToDataTable()


Found the answer: Delete data row from data table

Thanks Arivu