To find out the last non-empty cell in a column, use the code above and replace "COLUMN" with 1: Sub example() lastRow = Cells(Rows.Count, 1).End(xlUp).
確定! 回上一頁