OilEconomist
Active Member
- Joined
- Dec 26, 2016
- Messages
- 421
- Office Version
- 2019
- Platform
- Windows
Thanks in advance for your assistance. How would I modify the following line to get how many ever spaces I would like at the end of it. In this case let's say two so it changes from what I have in the first cell (D1) to the second cell (D2). They are both right justified, but D2 has two spaces at the end to ensure that it does not bunch up with what's in column E. See the code below the image.
This is what I have to format the cell currently. How would I modify?
This is what I have to format the cell currently. How would I modify?
VBA Code:
Range("D" & i).NumberFormat = "[>=1000000] #,##0.0,,"" m"";[>0] #,##0.0,"" k"";General"