How to delete rows (non-empty) from excel sheet/work sheet

[VenkatRamana]

Hello All,   can some one help me on below scenario.   I need to delete some of the records from excel sheet.   Thanks in advance   With Kind Regards          

[11235813sk]

If you the records as static, and you only want to use the VBO 1) Read excel to a collection 2) Delete the sheet 3) Delete the rows in collection 4) Write it back to the Excel.

[mc]

  Could you provide a better performance solution? That is time consuming. I'd like avoid read to a collection, there are many columns that I dont' need How does work the DELETE (Left/Up)? The document about says nothing. Thanks  

[TomaszAdamski]

I believe you can use Delete method. Just provide the correct shift value. you can start searching from this point. https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-delete-me…