0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

ある行や列のセルすべてをクリアしたい

Posted at

ある行や列のセルすべてをクリアしたい場合は、Range.ClearRange.ClearContents を利用します。

  • Range.Clear : すべてをクリアする(数式・値・書式・コメントなど)
  • Range.ClearContents : 数式と値をクリアする

例1: A列のセルすべてをクリアする

ThisWorkbook.Worksheets("Main").Range("A:A").Clear

例2: 3行目の数式・値をすべてクリアする

ThisWorkbook.Worksheets("Main").Range("3:3").ClearContents

環境情報

image.png

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?