The more common way to declare a variable to trap the last row using a Range reference. Dim lr As Long lr = Range("A" & Rows.count).End(xlUp) ...
確定! 回上一頁