![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
|||
|
|||
|
Well, I've just spent several hours trying various combinations of punctuation and special characters and none of them has had any effect. The latest I've tried are:
.Pattern = "[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!" & _ "#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:" & _ "[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:" & _ "[a-z0-9-]*[a-z0-9])?" and .Pattern = "[a-z0-9!#$%&'*+/=?^_`{|}~- ]" I don't know how else to tell the code to identify hits as whole word matches if they adjoin these characters. Am I getting warm or still cold here? |
|
| Tags |
| case, search, whole word match |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| how to speed up macro | AC PORTA VIA | Excel | 3 | 10-30-2015 08:58 PM |
| Excel formula required to speed up process of creating species rarefaction curves. Ecology! | Tim_F | Excel | 2 | 07-18-2014 04:56 AM |
word and keyboard speed
|
ptz | Word | 2 | 09-20-2012 06:37 AM |
Help -can i improve this way of working?
|
lucky67 | Office | 1 | 01-26-2012 09:20 PM |
Change how windows searches
|
cadams | Office | 1 | 12-07-2010 10:01 AM |