next available row

  • Thread starter Thread starter portroe
  • Start date Start date
P

portroe

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
 
NextRow = _
Application.WorksheetFunction.CountA(Range("b:b")) + 1

Just change the range column to your desired column.
 
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)
 
Back
Top