1 row to the other

[zaahir]

Hi
i add data to a spreadsheet using a userform. after having inserted the data i need the next row to be selected and then the new data added into that row.
Please advise me on how to do this!!!

Regards

 

[Joe4]

You first need to determine which column you are going to use to determine where the next row should go (you should pick a column that will always have data).

If it was column A, here is code that will select the first available row in column A (after the last row of data in column A with data):

Range("A65536").End(xlUp).Offset(1,0).Select

 

[zaahir]

Hi
oh, i have done that bt did nt specify the A & the number. Thanx,
will this code allow for multiple column entries i.e
row 5 data into col d, e, f etc?

Regards

 

[Joe4]

Once you have selected column A using that code, you can then post things in the other columns in the same row using the offset command, i.e.
if you are in column A and want to post something in column D of that row, you can use:
ActiveCell.Offset(0,3)
or
Cells(ActiveCell.Row, "D")