Insert new blank row in ms.excel using vb.net

How can I ins开发者_如何学Cert a blank row in Excel using VB.NET?

It looks roughly like this:

Dim range1 As Excel.Range
// set range location eg row 5  "5:5" 
range1.Insert(Excel.xlShiftDown, Excel.xlFormatFromRightOrBelow)

Try This method

sheet.Range("A1").EntireRow.Delete();