ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VB Find and Replace (https://www.excelbanter.com/excel-worksheet-functions/7501-vbulletin-find-replace.html)

Bony_pony

VB Find and Replace
 
Hi again,
Yes that works fine and thank you for your time. The
problem I have now is the original one in that looping
through each worksheet takes twice as long as doing a
workbook replace.

That wa the reason for me doing a workbook vs sheet
search in the first place.

Do you know how to address the Find / Replace drop down
in the Options menu?

Thanks again very muvh!

Regards,
Robert

Don Guillett

If you do this a LOT, use this addin.
http://www.jkp-ads.com/OfficeMarketPlaceFF-EN.htm

--
Don Guillett
SalesAid Software

"Bony_pony" wrote in message
...
Hi again,
Yes that works fine and thank you for your time. The
problem I have now is the original one in that looping
through each worksheet takes twice as long as doing a
workbook replace.

That wa the reason for me doing a workbook vs sheet
search in the first place.

Do you know how to address the Find / Replace drop down
in the Options menu?

Thanks again very muvh!

Regards,
Robert





All times are GMT +1. The time now is 08:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com