Question Excel Insert new row

[rchiu5hk]

Dear all,

I try to insert new row under row 22 but it prompt error . Do you know how
to correct?
-----------------------------------------------------------------------
objSheet = objExcel.Sheets("EK")
objSheet.Rows("22:22").Select() ' Prompt error
objSheet.Selection.Insert (Shift:=Excel.XlDirection.xlDown) ' don't know
it is correct or not in this syntax.
-----------------------------------------------------------------------------

Please help me!

 

[rchiu5hk]

Solved

Dear all,

Change
objSheet.rows("22").copy()
objsheet.rows("22").insert shift:=xldown