VBA count value starting from the second line with no header

[Palucci]

Hi,
I would like to count how many items there are in a given row, but that it starts with A2 and not with A1. When I have this code, I get an error
"Appplication - definied or object definied error"
my code :

wb.Sheets("C_3402_0002").Range("G9") = wbMe.Sheets("pochodne").Range("A2:A").Cells.SpecialCells(xlCellTypeConstants).Count

 

[Peter_SSs]

wbMe.Sheets("pochodne").Range("A2:A")

This range has no ending row number

 

[Palucci]

This range has no ending row number

i resolved this : wb.Sheets("C_3402_0002").Range("G8") = wbMe.Sheets("pochodne").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count - 1

 

[Peter_SSs]

i resolved this : wb.Sheets("C_3402_0002").Range("G8") = wbMe.Sheets("pochodne").Range("A:A").Cells.SpecialCells(xlCellTypeConstants).Count - 1

That is one way to give the range an ending number (1,048,576).