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 |
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 |
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 |
All times are GMT +1. The time now is 11:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com