![]() |
|
![]() |
|
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 | 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 |
![]() |
ptz | Word | 2 | 09-20-2012 06:37 AM |
![]() |
lucky67 | Office | 1 | 01-26-2012 09:20 PM |
![]() |
cadams | Office | 1 | 12-07-2010 10:01 AM |