View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
 
Posts: 493
Default Error Msg: 'No Cells were found'

One thing I didn't include is that you need to have an On Error
Resume Next...On Error Goto (or a pointer to your error handling
routine) bracketing the call to SpecialCells, othewise Specialcells
can still throw a run-time error.


In article ,
"Stuart" wrote:

Yes, qualifying worked.
Thanks also for the test advice.