I assume that the data from the form needs to go in the next row of an Excel sheet?
You’ll want to declare a variable then loop through looking for the next blank row. Something like this will be what you are looking for.
<pre>dim i as integer
do until range(“A” & i).value = “” ‘Change A to what ever column you need to monitor.
i = i + 1