Hi
I use code to paste info off a userform into a spreadsheet, save the data and close the sheet again. Now i need to the code to select the next row to the data to a new row i.e.
!st entry goes into Col A, b, c, d, e Row 1. I need the code to select row2 & add the data there i.e ColA, b, c, d, e row2 there after row3 then 4 etc.
i now keep overwriting row1...
Please Help!!!!
I use code to paste info off a userform into a spreadsheet, save the data and close the sheet again. Now i need to the code to select the next row to the data to a new row i.e.
!st entry goes into Col A, b, c, d, e Row 1. I need the code to select row2 & add the data there i.e ColA, b, c, d, e row2 there after row3 then 4 etc.
i now keep overwriting row1...
Please Help!!!!