nikolaikolev
New Member
- Joined
- Nov 22, 2011
- Messages
- 24
Dear,
i use the following macro to change the cell format of a single column (AY), but i want to change the cells format in a few columns that are not next to each other (for example columns A, W, AA, BW)
How can I do that ?
With Sheet1.Range("AY8", "AY10000")
.NumberFormat = "$#,##0.00"
.Value = .Value
End With
i use the following macro to change the cell format of a single column (AY), but i want to change the cells format in a few columns that are not next to each other (for example columns A, W, AA, BW)
How can I do that ?
With Sheet1.Range("AY8", "AY10000")
.NumberFormat = "$#,##0.00"
.Value = .Value
End With