Hi eveyone
I have absolutely no idea how to get starting on this one. I've got a long string in cell B1.
At some point there is the word "oms:SomeString," (without the quotes). I need to know whether SomeString is somewhere in the active sheet or not (the workbook running the VBA-code is not the active sheet)
I can't just compare the cell B1 because it contains multiple words. Any hints are very welcome.
Cheers,
Jeroen
Last edited by Jeroen1000; 10-12-2009 at 08:15 AM.
I've been doing some thinking. This piece of code searches for the string
But I can't get it to return true of false. But it has given me more ideas on how to search the forums. I bet this question has been answered before.
Please Login or Register to view this content.
Hi
Set a reference to the found cell and then check whether the found cell actually exists (ie whether the searched for term was found):
Make sense?Please Login or Register to view this content.
Richard[/code]
Richard Schollar
Microsoft MVP - Excel
Brilliant mr. Schollar. I was toying with the idea but couldn't quite get it right. Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks