I have a list of information in column A of a worksheet. I want to check each cell, to see if it is contained within a string, and if so display a msg box"found"
I have a list of information in column A of a worksheet. I want to check each cell, to see if it is contained within a string, and if so display a msg box"found"
without seeing what you are working with...try =if(isnumber(search()),"Found",""), copied down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
what/where is your prefered string?
ConnectorNum is a string that I am searching in. It is defined earlier. This above code doesn't work however, I get type mismatch on the testvalue line..Please Login or Register to view this content.
Any ideas?
Few errors
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks