Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
next available row
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|