Hello,

I am trying to insert concatenate Formula in Excel file in A Column from 2nd row till last used row. I am able to insert the formula but it is not incrementing. So can anyone please help me to fix this.

I used Invoke Code option

Failed_Filtered_Remark.AsEnumerable().ToList().ForEach(Sub(row) row(“Remark”)= “=B2&D2&E2”)

I want to know how to increment this.

Below is excel screen shot.