smart_beta
New Member
- Joined
- May 16, 2020
- Messages
- 10
- Office Version
- 2019
- Platform
- Windows
Hi - why doesn't the following syntax work?
I'm inside the VBA editors and have typed the following
? 1 + 1
result: should be 2
what I get is:
Print 1 + 1
also:
I type:
? application.name
and the results I get is Print application.name, when I should get "Microsoft Excel"
and finally,
in sheet1 cell A1 I have the string " hello world"
I type this in the editor:
? worksheets(1).Range("A1"). value = "hahaha" and hit enter
and I get this and nothing happens:
Print Worksheets(1).Range("A1").Value = "hahaha"
What is going on? Thank you!
I'm inside the VBA editors and have typed the following
? 1 + 1
result: should be 2
what I get is:
Print 1 + 1
also:
I type:
? application.name
and the results I get is Print application.name, when I should get "Microsoft Excel"
and finally,
in sheet1 cell A1 I have the string " hello world"
I type this in the editor:
? worksheets(1).Range("A1"). value = "hahaha" and hit enter
and I get this and nothing happens:
Print Worksheets(1).Range("A1").Value = "hahaha"
What is going on? Thank you!