The macro doesn't really go WS1 either. I'm trying to give specific instructions and somehow you're missing them.
Fix that first.Insert > Module to add a normal module and put the code in there.
========
I was sure I'd put in the no duplicates thing, but there is an error in the logic, sorry about that.
...that needs to be corrected.
If InStr(wrd.Offset(0, 5), rFind.Offset(0, 1)) = 0 Then _
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Wooow it works!!
Thank you very much it works great! And the thing with changeable "Max" is really cool.
I am sorry! I missed that but now i read helps pages online how to add a module! and id did it.The macro doesn't really go WS1 either. I'm trying to give specific instructions and somehow you're missing them.
It works thank you very much. Now i will start it on my real data and keep praying for your long life and being thankful to your help !! :-)
thanks a million times
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks