VBA復習

(ｍｓｇｂｏｘ　（”ｈｅｌｌｏ　ｗｏｒｌｄ”）)

MsgBox ("hello world")

(ｗｏｒｋｓｈｅｅｔｓ（”ｓｈｅｅｔ１”）．ｒａｎｇｅ（”ａ１”）)

Worksheets("Sheet1").Range("A1")

(ｒａｎｇｅ（”ａ２”）．ｖａｌｕｅ　＝　”ｈｅｌｌｏ２”)

Range("A2").Value = "hello2"

(ｃｅｌｌｓ（３，　１）．ｖａｌｕｅ　＝　”ｈｅｌｌｏ３”)

Cells(3, 1).Value = "hello3"

(ｃｅｌｌｓ（３，　１）．ｏｆｆｓｅｔ（１，　０）　＝　”ｈｅｌｌｏ４”)

Cells(3, 1).Offset(1, 0) = "hello4"

(ｒａｎｇｅ（”ａ１”，　”ｂ３”）．ｖａｌｕｅ　＝　”ｈｅｌｌｏ”)

Range("A1", "B3").Value = "hello"

(ｒａｎｇｅ（”ａ５：ｃ７”）．ｖａｌｕｅ　＝　”ｈｅｌｌｏ２”)

Range("A5:C7").Value = "hello2"

(ｒａｎｇｅ（”４：４”）．ｖａｌｕｅ　＝　”ｒｏｗ　４”)

Range("4:4").Value = "row 4"

(ｒａｎｇｅ（”ｃ：ｃ”）．ｖａｌｕｅ　＝　”ｃｏｌｕｍｎ　ｃ”)

Range("C:C").Value = "Column C"

(ｃｅｌｌｓ．ｃｌｅａｒ)

Cells.Clear