I am currently using the find function and it works well, however I am going to be passing this off to our tool room guys for keeping track of where tools are etc... and I don't want to have to rely on the casing being correct...
Any help would be greatly appreciated!
Thanks in advance,
TeeJayShelton
Last edited by TeeJayShelton; 06-03-2010 at 11:01 AM. Reason: Solved....
Hell TeeJay,
Are you talking about FIND worksheet function? If so you can use SEARCH as a non case-sensitive (or case-insensitive) alternative
Have a look at the SEARCH function.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Thank you both very much that works perfectly.... Sorry for the simple questions.... I clicked to add to both of your reps. for entertaining it....
Thanks again
How can I find text within text but not case sensative... VBA code required , I have code which a case sensitive and exact word should be written
roypabitra...
Welcome to the Forum, unfortunately:
Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks