phoenixsuun
New Member
- Joined
- Jan 31, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a spreadsheet with two values that need to be added and printed. I currently have this:
This code adds the values together but when I print myVar, there is no comma. How can I make sure there is a comma in my numbers?
Example: 1,000 + 50 = 1,050 NOT 1050
VBA Code:
myVar = Range("C8").Value + Range("S8").Value
This code adds the values together but when I print myVar, there is no comma. How can I make sure there is a comma in my numbers?
Example: 1,000 + 50 = 1,050 NOT 1050