billandrew
Well-known Member
- Joined
- Mar 9, 2014
- Messages
- 743
Hello All
trying to format one range of text to a percentage and a different range to a value. Code I am using below
<colgroup><col width="72" style="width:54pt"> </colgroup><tbody>
</tbody>
trying to format one range of text to a percentage and a different range to a value. Code I am using below
Range("D5:G64,L5:O64").Select |
Selection.NumberFormat = "0.0%" |
.Value = .Value |
Range("H5:K64,P5:S64").Select |
With Selection |
Selection.NumberFormat = "General" |
.Value = .Value |
<colgroup><col width="72" style="width:54pt"> </colgroup><tbody>
</tbody>