next available row
NextRow = _
Application.WorksheetFunction.CountA(Range("b:b")) + 1
Just change the range column to your desired column.
"portroe" wrote in message
...
Hi
I am collecting a selection of data using input boxes on my excel table
how do I identify the next empty row for entry of this data on the
worksheet?
thanks
portroe
|