next available row
Assuming column A is the key identifier column
Cells(Rows.Count,"A").End(xlUp).Row+1
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"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
|