Using the Find function in Excel

[Richard Argent]

Im having difficulty using the Find function in Excel 97.
I have a spreadsheet with 14 sheets. When i use the Find
function to search for data contained within the
spreadsheet, the Find function only searches the
highlighted. Even if i highlight all sheets, the Find
function only searched the sheet marked in bold (even
though all sheets are highlighted). Searching for a single
piece of data is very time consuming as i am having to do
the Find 14 times (once for each sheet). Is there a way of
searching all individual sheets within a spreadsheet,
without having to do the search for each sheet? If Excel
does provide this function, then is there any add-on
software (free or otherwise) that could perform this Find
function?

 

[Bob Phillips]

Richard,

Get hold of Jan Karel Pieterse's FlexFind utility at
http://www.jkp-ads.com/Download.htm


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)