Cells rows count 1 end xlup. Vba find last row in file. specialcells(). activecell.row.