How to Insert a new row to Excel

[JosephJohn]

I am working on designing a solution where two different excel sheets are compared. I have to add a row from one excel page to another. For this i am initially inserting a new row at a particular position and adding the cell values. Is there a way to insert a new row at a particular position in an excel document? Is that using the in built Excel VBO/ using a keystroke approach? Thanks,

[TimGrassam]

Hello Use the Select Action to highlight the entire row, then use the Insert Action with the Shift input parameter set to ""up

[JosephJohn]

Thank you Tim.

[JosephJohn]

I could however select only one cell (like ""A162""). How could i select an entire row using Select?(Is there something like ""A162-K162""?)

[Ravindersaini]

You can do the same by going to the cell ""A162"" and to select the entire row use send key events ""Shift + Right arrow/End."" Regards, Ravinder Saini

[ArunSingh]

How to select entire row, I am able to select only one cell at the time with Select method of MS Excel VBO