View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DoooWhat DoooWhat is offline
external usenet poster
 
Posts: 37
Default 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