Searching Entire WorkBook?

[Niemsters]

I'm a relativly new VBA user, so this may be a rather elementary question, but: Is there a way to search for a text string through the entire workbook instead of searching each page individually?

My wookbook has 100+ worksheets with lots of data and calculation, and inputs new data as well. However occasionally there are "NA" figures which mess up my equations that I want to delete. This is a text string NA from an outside source, not the tpical #NA error Excel gives.

Any advice would be appreciated, I'd like to do this without searching each page individually...

 

[SteveO59L]

If you are using Excel 2003, each worksheet has (256 cols x 65, 000+ rows), thats more than 16 million individual cells.

If you have 100 worksheets, thats makes it in excess of 1 billion cells.


Do you really need to look at all of them ?

 

[Andrew Fergus]

Hi

Have you looked at using the standard replace functionality? See menu option Edit > Replace > here you can search for specific things (in your case "NA" in the entire workbook), and replace with either nothing or a zero. I'm not sure of the limitations for this function but it sounds like a lot of data!!

Andrew