I have a spreadsheet with columns full of values that are sorted ascending. In my vb program I have recordsets with values that need to be inserted into the spreadsheet columns in order. How do I search through the columns in excel and insert my recordset values in the appropriate position.

for example: my record set: 2, 4 , 8, 9

column A: 1, 3, 7, 15

I need to insert my record set into column A so the it looks like:

column A: 1, 2, 3, 4, 7, 8, 9, 15

Note: I need to do this by adding entire rows and not just shifting cells.

Im not familiar with using VB to navigate through excel worksheets and getting values, any help is appreciated.