View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerry Verschuuren Gerry Verschuuren is offline
external usenet poster
 
Posts: 18
Default Check SpecialCells(xlCellTypeBlanks) for 0 blanks

How do I check whether the Range returned does have cells in it - otherwise
you would get an runtime error. Checking with Null, Empty, Error, etc. does
not work.