Thread: Cell Clearing
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
trward79 trward79 is offline
external usenet poster
 
Posts: 20
Default Cell Clearing

Nevermind, I set the followin in place

For Each cell In Range("B7:F100")
If LCase(cell.Value) = "0" Then
cell.Resize(1, 5).ClearContents
End If
Next



"trward79" wrote:

I have a spreadsheet that has alot of 0.00 values in a range of B8:F95 I need
these values to be cleared so I can print with no values in place.