Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
The following code will clear the content of a cell that contains a
formula and whose result is zero. MAKE A BACKUP COPY of your data before you use this, so you can be sure it does what you want it to do! Sub Scrub() Dim nCell As Variant For Each nCell In ActiveSheet.UsedRange If nCell.Value < "" And Mid(nCell.Formula, 1, 1) = "=" And _ nCell.Value = 0 Then nCell.ClearContents Next nCell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can cells containing linked formulas be identified? | Excel Discussion (Misc queries) | |||
formulas and cells | Excel Worksheet Functions | |||
how do i add cells in checkbook register template with formulas? | Excel Worksheet Functions | |||
Min Formulas in #VALUE! Cells | Excel Worksheet Functions | |||
How do you show formulas in certain cells only (not the whole she. | Excel Worksheet Functions |