View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike[_40_] Mike[_40_] is offline
external usenet poster
 
Posts: 10
Default Negative Value not computing

I have the following code:

Worksheets("Worksheet").Cells(81, 3).Value = -0.01 Then ...

In cell C81 the calculated value is -.01, but when the
code executes it does not evaluate as -.01. But it does
return -.01 when I make it post value to a cell.

Why doesnt it want to evaluate properly in the formula?

TIA
Mike