LoginSignup
0
1

More than 3 years have passed since last update.

【VBA】セルの値の取得

Last updated at Posted at 2021-04-19

◆セルの値の取得

Range.Valueは変数のように読み書きできる。

セルの値の取得
Sub sample()
    'A1に100を代入
    Range("A1").Value = 100
    'A1の値(100)を取得してxに代入
    x = Range("A1").Value
    'xの値を表示
    MsgBox (x)
End Sub
0
1
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
1