Macro, how to set a cell value to zero

[Khoshravan]

I am a newbie in VBA.
I want to set a cell value to zero after For and before Set statement in the
following MAcro. How can I do that.

Sub RoundToZero1()
For Counter = 1 To 12
Set curCell = Worksheets("Sheet1").Cells(Counter, 3)
If Abs(curCell.Value) < 0.5 Then Cells(Counter, 4) = "These numbers
are lass than 0.5"
Next Counter
End Sub

 

[Chris Bode via OfficeKB.com]

You can just use the
Worksheets("Sheet1").Cells(row,col).Value=0 statement to set the cell value
to zero.


#
Sub RoundToZero1()
For Counter = 1 To 12

Worksheets("Sheet1").Cells(Counter, 3).Value=0

Set curCell = Worksheets("Sheet1").Cells(Counter, 3)
If Abs(curCell.Value) < 0.5 Then Cells(Counter, 4) = "These numbers
are lass than 0.5"
Next Counter
End Sub
#


Hope this works

Have a nice time

Chris

 

[Khoshravan]

Thanks for your comment.
Isn't it possible to eliminate the first part:
Worksheets("Sheet1").