Sub 定位到B列最后一行()
Cells(Rows.Count, “B”).End(xlUp).Select
MsgBox “B列最后不是空的一行是:” & Cells(Rows.Count, “B”).End(xlUp).Row
End Sub
Sub 定位到B列最后一行()
Cells(Rows.Count, “B”).End(xlUp).Select
MsgBox “B列最后不是空的一行是:” & Cells(Rows.Count, “B”).End(xlUp).Row
End Sub