Subscribe in a readerFlexfind: Search and replace made easy
Is free of charge and works in Excel 97, 2000, XP, 2003, 2007 and 2010.
if you really like it:Excel 2007 and 2010
Flexfind2007.zip v5.3, build 572 (4 Jan 2012, Downloaded: 15319 times)
This is the 2007 and 2010 version, cannot be used with older versions. See below for more information on the tool.
Excel 97 to 2003
Flexfind.zip v5.3, build 572 (4 Jan 2012, Downloaded: 39636 times) See Screenshot
Flexfind eases searching throughout an entire workbook. Enter a string to search for and get a list of all found locations. Click on an entry to go there. Select workbook, sheet or range searching. Replace with another string in the found items you select. At your wish, get a confirmation for each occurrence found (also within one cell). MAC enabled (thanks to Matthew Henson). Ever needed to replace a company name in the title of 25 charts? Or replace just the third occurrence of a cell address in some cells' formulas? Or change a part of the printheader of 6 sheets? Now there is Flexfind, which enables Search and Replace in all these items and more!!!
Changes in 5.3 Build 572:
Small bugfix.
Alas, this version will not work on a mac. For Mac users, Flexfind 5.1 (Downloaded: 3643 times) is still available.
Instructions: Download the zip file by clicking the link above that says "Flexfind.zip". Unpack the files in the zip file to a folder of your liking and open the file called "Setup Flexfind.xls". Press the button in that file to install.
Click here to request support or issue comments or suggestions on this product.
Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.
Comments
Showing last 8 comments of 164 in total (Show All Comments):Comment by: Why Tea (12/5/2011 1:07:57 AM)I'm running v5.3 on XP and Vista, it's a great tool indeed especially when I need to search for a string in a huge spreadsheet full of drawing objects. Thanks for creating such a useful tool!
However, I did notice the run-time '50290' error from time to time as a few others have already reported. I usually have to restart Excel to get rid of the problem. Sometimes I have to restart a few times. Will be great if this problem can be fixed.
/WT
Comment by: Jan Karel Pieterse (12/5/2011 1:31:26 AM)Hi Why,
Thanks for reporting. Could you perhaps email me a small example file which exhibits the problem? Please also explain what string you searched for and which settings you used in Flexfind.
See email address near bottom of this page.
Comment by: Why Tea (12/15/2011 5:22:50 AM)Hi Jan,
Sorry I can't really email you this file as it's something from work. Is it possible for you to create a debug version so that I can collect some info for you when the problem occurs? The problem can be reproduced quite easily.
/WT
Comment by: Jan Karel Pieterse (12/15/2011 5:57:49 AM)Hi Why,
Can't you just remove (almost) everything from that offending file, except for the part that triggers the error, before sending it to me?
Comment by: Ben (1/3/2012 10:40:23 AM)I am also seeing error 50290. I will send a sample file so you can reproduce the issue.
Comment by: Jan Karel Pieterse (1/3/2012 11:56:27 PM)Hi Ben,
I fixed that issue with Build 572.
Comment by: Adam (1/26/2012 7:24:23 AM)We are having trouble with this add-in crashing Excel 2010 when opening a new excel document and then close it out. I am able to close documents that contain data without it crashing but for some reason when closing a new document Excel crashes. I have had this happen on three different computers.
Comment by: Jan Karel Pieterse (1/26/2012 7:41:12 AM)Hi Adam,
Odd, because there is no code in Flexfind that responds to opening or closing Excel files. Are you SURE this is caused by Flexfind?
Have a question, comment or suggestion? Then please use this form.
If your question is not directly related to this web page, but rather a more general "How do I do this" Excel question, then I advise you to ask your question here: www.eileenslounge.com.