clear cells using VBA

[khickey]

I need to clear all cells in a column that have a particular value. The value is sometimes a constant like "0" (zero) and sometimes is a value based on a formula. Is there a VBA code that will allow me to select those cells in column matching a particular value and clear them?

Cheers

 

[NateO]

VLookup() is Volatile?

 

[prinzip]

This should work on formulae results or values:

Sub deltime()
For Each Cell In [a:a]
If Cell.Value = "0" Then Cell.ClearContents 'put any value you want here
Next Cell
End Sub

Change [a:a] to the appropriate column. Hope this helps.

How do you declare the Cell here with option explicit? Dim as what?

 

[VoG]

Dim Cell as Range