If you have an Excel worksheet you can do the following directly in the application: (The result of a capture macro)
Range("F3").Select
Application.CutCopyMode = False
Selection.Copy
Range("A3").Select
Selection.Insert Shift:=xlDown
which essentially selects one or more cells from one location, then selects a new location and pastes the copied cells at the new location, pushing down the cells at the new location, preserving formatting and updating any formulas.
How would this be done using XLSIO method calls?