Hi,
I have requirement
I have requirement
- Open xsl file and delete all rows where email address (in some column) contains “Val1” or “val2”.
- I have used MS excel VBO to get in to collection and looped that collection and kept decision whether [clo.fieldname] = val1 or val2 using instring if the decision is true then deleting the rows from the collection else it its looping back again.
- In this case if the column value is not having val1 or val2 i am connecting back to loop but here its always checking with 1st row its not looping.
- Any body has idea how to resolve this?