View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cyberwolf Cyberwolf is offline
external usenet poster
 
Posts: 18
Default #N/A search across multiple worksheets.

I have several worksheets that can contain upwards of 2000 rows of data. I
need to be able to search all used cells on all of these sheets looking for
the #N/A error.

What would be the easiest way of accomplishing this without having to run
through each cell looking fo the error?

I was thinking of using the ISNA function but am unsure how to accomplish
this.

TIA
--
Cyberwolf
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf