Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have the following script in an excel spreadsheet;
Dim i As Integer Public Sub test() For i = 8 To 31 If Cells(i, 12) < 0 Then Cells(i, 12) = "0.00" End If Next i End Sub It checks a column for values that are negative and changes them to "0.00", is there a way i can check the whole spreadsheet for negative numbers and change them to "0.00" |