TheGREATrandino
New Member
- Joined
- Sep 9, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
Is it possible to store and format a value to a cell in a nested statement in excel vba?
For example,
Range("A2").value = 123445.34
range("A2").NumberFormat="#,##0.00"
both statements work and produce the desired results. How do you do something like Range("A2").value = 123445.34, format "#,##0.00"
Is it "better" to set the formatting in VBA or through the GUI on the sheet?
TIA
Randino
For example,
Range("A2").value = 123445.34
range("A2").NumberFormat="#,##0.00"
both statements work and produce the desired results. How do you do something like Range("A2").value = 123445.34, format "#,##0.00"
Is it "better" to set the formatting in VBA or through the GUI on the sheet?
TIA
Randino