Calculation Rounding

[horsehead60]

Is there a way to set an entire spreadsheet to roundup all formulas??? Can the way excel calculates be changed in this way for all calculations???

Thanks in advance...

 

[Corticus]

Hi,

I don't believe there is a setting for this, but this code:

Private Sub Worksheet_Change(ByVal Target As Range)

Application.EnableEvents = False

If Round(Target) < Target Then
Target = Round(1 + Target, 0)
Else
Target = Round(Target, 0)
End If

Application.EnableEvents = True

End Sub

Should do it.

HTH,
Corticus