I have an issue with the DeleteRows function excersied on an excel file with over 25k rows. The DeleteRows function works fine on rows uptill around 15000 - 18000 th row i believe. If i try to use it for deleting rows over 20000 it is inserting over a thousand blank rows each time while not deleting the row i intend to. It is the same thing with the use of a DeleteRow function too. But the RemoveAt function works in clearing the elements at that row index, but i need to delete the entire row. Any helpful information or work around will be appreciated.