Match string with USA sheet and color substring in other sheets
Match string with USA sheet and color substring in other sheets
Is it just me, or does anyone else feel offended by what I consider to be laziness by the OP to just throw up a few words and a workbook and leave us to figure out exactly what he means and what he wants?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I've raised this with him by PM
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Same question here:
http://www.vbaexpress.com/forum/show...th-given-color
My apologies Xld and to all for unclear question with few words. I will take care of it further.
Tom Jones: My apologies not same excel book. And this resulted because I have written a question with few words where nothing is clear.
Let me try to clarify:
1. Sheet named USA is a reference sheet and will contains multi para long strings.
Each string in the sheet is given an unique color.
2. In other sheets long string is there. This sheets can be in any number and string can appear in any row or column; any where; may be multiparagraphed.
3. I am looking for a VBA to find match (to color upto four continuous cheracter) in other sheets that is matching with the reference sub-strings.
4. If the reference sting is long then VBA will "match discountinuous parts of reference matching sub-string" and will use the color of the reference string.