Greg Truby
MrExcel MVP
- Joined
- Jun 19, 2002
- Messages
- 10,025
Well, I'm glad this just happed to occur in something where it wasn't mission critical...
Try this:
Try this:
Code:
Sub foo()
For p = -1 To 1 Step 0.2
With Cells(1, (p + 1) * 5 + 1)
.NumberFormat = "0%_);[Red](0%);0%"
.Value = p
End With
Next p
End Sub
- What do you get in F1? I'm getting -5.55111512312578E-15%
- What do you get in K1? I'm getting nothing: the loop does not execute for p=1