return the next row
 

i need a macro that can return the next row after a range
of data. that is say i have a userform with TextBox1 and
CommandButton1. also i have a data table going from
A2:J100. I need the value in TextBox1 to go into A101
after the button is clicked. and then the next record
will go into A102, etc. i have the range A2:A100
named "RANGE" and it refers to "=OFFSET(A2,0,0,COUNTA
(A:A),1)" so the name will continue with A2:A101 and so
on. TIA