VBA (4) Clear a column

xiaoxiao2021-03-06  37

SUB Ellipse 4_Click ()

Dim yyy as integer

YYY = Application.WorksheetFunction.counta (Column ("a")))

Range (Cells (1, 1), Cells (YYY, 1)). ClearContents

End Sub

Counta (Range ("A: A")) = Counta (Column ("A")

转载请注明原文地址:https://www.9cbs.com/read-61171.html

New Post(0)