Hi,
Below code search "Created" and then copy the entire rows to paste in Dump1 sheet. Problem is, it do not find the exact word "Created".. If there is column with "Created by" it sometime also pulls that column.
How to make it exact search?
Please Login or Register to view this content.
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Here is what i use to search and it appears to search for only the exact wording that the user has put in the msgbox
Please Login or Register to view this content.
Thank those who have helped you by clicking the Star * below their name and please mark your post [SOLVED] if it has been answered satisfactorily.
Thanks Jesse. But I want to avoid the input box.
got it working by adding LookAt:=xlWholePlease Login or Register to view this content.
You can have thepart changed to reference a cell or something you put hardcoded into the macro. That is up to you if you don't want to input box.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks