Get the row number of the the end of one column

[Helder Barros]

I need to get how many rows are written in a column in a excel sheet. If bettwen the rows there are not anyone emtpy i dont have problems using:

XXX=Spreadsheet1.Columns(1).End(xlDown).Row

However, with empty rows, this command will return then number of the row before the first row empty.

Can you help me?