I would like to create a code so that if .15 appears anywhere in the range E40:E then “Found” will be entered into M39. When I use the code below I get an error message that reads “Method of Range of object_Global failed. Can you help?
Please Login or Register to view this content.
Last edited by Sal1; 06-11-2011 at 03:30 PM. Reason: SOLVED
This line will do it:
Please Login or Register to view this content.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Works like a charm Dave. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks