brucebru Posted May 8, 2013 Share Posted May 8, 2013 (edited) Greetings, I am looking for a script to search for a specific word in a specific column of an opened Excel document. Once he found the word that i'm looking, I need to see all ligne with that specific word inside. I try many many script from this forum but I still can not find a solution to what I am looking for. Any help will be a lot appreciated. Thank you Edited May 8, 2013 by brucebru Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted May 8, 2013 Moderators Share Posted May 8, 2013 (edited) Hi brucebru, welcome to the forum. You mention you have tried many scripts from this forum, how about posting what you have so far? We are not in the business of writing code for you, but we're happy to help. To begin with, I would suggest some light reading in the help file under _Excel, or you can use Water's great ExcelEX UDF: Edited May 8, 2013 by JLogan3o13 "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
water Posted May 8, 2013 Share Posted May 8, 2013 You could have a look at my ExcelEX UDF (for download please check my signature). Function _Excel_RangeFind should do what you want. But be warned: Its an early alpha version subject to changes! My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
brucebru Posted May 8, 2013 Author Share Posted May 8, 2013 JLogan3o13, water, thanks a lot for your reply, I am going to take a look of what you suggest me :-) Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now