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?
