Writing to Excel

[samtaylor08]

Hi Rob
I have got this code, I want it to write first line of listbox1 the a , and then the first line of listbox2, then I want it to go to a new line. This is my code, but it overwrites each time obviously, but I didn't know how to do append the cell so wrote this so someone could modify:

objExcel.Range("F" & lRow.ToString).Select()
            For index = 0 To lstproname.Items.Count - 1
                objExcel.ActiveCell.FormulaR1C1 = lstproname.Items(index)   & _    ", " & lstproprice.Items(index) &  vbNewLine
                index = index +1
            Next

Thanks

Sam