Macro- Find
Cell A1 thru A100 has area codes 661, 213 etc would like to add a button to run a macro the Find function and the user would input area code they are looking for and the find function would locate the are code in question. I have ran marco using Ctrl+F, and also selecting FIND on the ribbon, it does not work, do you have a suggestions.
Thx
Look at the .Find method in the Excel VBA help files
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks