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 have written some text on column A
I have 10 sheets. how to use find one time so i get i result.
Thanks
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.
QuoteOriginally 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
Don’t have an account yet? Register yourself now and be a part of our community!