delete rows in excel worksheet

[nilaavu]

  

 oSelection = DirectCast(csheet.Rows("1:2"), Excel.Range)
 oSelection.Delete()

How can I delete the first 2 rows in an excel worksheet?
Apprantly the above code does nothing .
Please help
thx

[ProphetBeal]

did you try this?

csheet.Rows("1:2").Delete

[Siddharth Rout]

Further to what ProphetBeal suggested try this

csheet.Rows("1:2").Delete Shift:=xlUp

[stimbo]

'Could you do a loop?

For i As Integer = 1 to 2 Step 1
            Dim oSelection As myExcel.Range = DirectCast(oSht.Rows(i, ), myExcel.Range)
            oSelection.Delete()

Next