Thru code I'm trying to copy, paste special as values. Here's what I have:
With vRng
.Formula = [formula put in several columns]
.Value = .Value
End With
It's working but is truncating values.
The formula evaluates to 0.013 but gets entered into cell as 0.01.
Precision As Displayed is not on.
Any ideas what's happening or suggestions for an easy fix or replacement for the .Value line?
With vRng
.Formula = [formula put in several columns]
.Value = .Value
End With
It's working but is truncating values.
The formula evaluates to 0.013 but gets entered into cell as 0.01.
Precision As Displayed is not on.
Any ideas what's happening or suggestions for an easy fix or replacement for the .Value line?