I'm trying to copy 4 rows in an Excel Worksheet and then Insert copied cells so I can duplicate the 4 rows for each object in a selection set. I can open Excel and set the Workbook and Worksheet current but I don't know how to put the rows into the clipboard and insert them back in. I may have been able to isolate the rows with:
The rows1 object has a count of 4. This was only accomplished by manually selecting the 4 rows which I don't want to do. I would like to make the selection programmatically.
My goal would be to open the Worksheet and place the 4 rows, 17-20, into the Clipboard and Insert them back in beneath the original 4 rows, 21-24 etc..., repeatedly based on how many objects the user has placed into a selection set.
Can anybody offer some help as to where I can find how to do this?