Set Range as cells with specific value
I would like to replace the last section of this code
[SpecialCells(xlCellTypeBlanks)] with something that tells excel to
look for cells with the value "0" in it.
Set rng = .Range(.Cells(2, col), .Cells(LastRow, col)) _
.Cells.SpecialCells(xlCellTypeBlanks)
I am sure this is very simple, just not sure how to do it. As always,
any help is very much appreciated.
Kevin
|