Thanks smartin,
Your post helped me solve a question I posted today "end(xldown)


"smartin" wrote:

FSPH wrote:
Hello there,

Several of my worksheets contain a column (e.g., colum 5) of data with
varying length. Worksheet 1 may have 10 rows of data, worksheet 2 with 20
rows of data. The first two rows are occupied by the header on all worksheets.

How can I count the maximum of rows with data?

I encountered this code: Cells(Rows.Count, "a").End(xlDown).Row
but unfortunately it doesn't work properly (probably because I don't
understand what exactly the code is doing).

Thank you, I would be grateful for your help.

Maybe this:

Function CountRows(ByVal MyRange As Range) As Long
CountRows = Application.WorksheetFunction.CountA(MyRange)
End Function