Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Inserting rows
Hi All,
I have a Excel sheet with some data and a COM addin written in C# to manipulate the data in sheet. I want to insert an entire row between the two consecutive rows in sheet and also copy the data from the previous row to the new row cell by cell. I am a struggling with this for a bit. Any suggestions or help will be appreciated. Thanks and Regards Niranjan Marathe |
#2
|
|||
|
|||
the following macro inserts row no. 5 (i.e.a row after row 4) and insert
row4 on row 5 Public Sub test() Rows("5:5").Insert Range(Range("A4"), Range("a4").End(xlToRight)).Copy Range("a5").PasteSpecial Application.CutCopyMode = False Range("a1").Select End Sub is this what you want Niranjan wrote in message ... Hi All, I have a Excel sheet with some data and a COM addin written in C# to manipulate the data in sheet. I want to insert an entire row between the two consecutive rows in sheet and also copy the data from the previous row to the new row cell by cell. I am a struggling with this for a bit. Any suggestions or help will be appreciated. Thanks and Regards Niranjan Marathe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Rows w/formulas question | Excel Worksheet Functions | |||
inserting rows through external data source | Excel Discussion (Misc queries) | |||
Searching for data and inserting new rows | Excel Discussion (Misc queries) | |||
inserting a row between two existing rows | New Users to Excel | |||
Inserting Multiple Rows with Formulas | Excel Worksheet Functions |