#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
|