How to find a text in 10 sheets at the same time.

Using OfficeXP

Edit>Find

Under Options Select EntireWorkbook for Search Within option.

You really should specify if you want to use VBA, Formula or if you are just asking in general and also what kind of result are you looking to get.

Quote

Originally posted by s_u_resh
i have written some text on column A

I have 10 sheets. how to use find one time so i get i result.

Thanks

I suggest you download the free FlexFind add-in, available from the following URL:

http://www.bmsltd.co.uk/mvp/MVPPage.asp

A brief description of what it does:

"This utility searches for a string throughout an entire workbook (all worksheets, one sheet or current selection). "

HTH

Cheers,

John