|
|
|||||||
|
 Segregate or highlight the cells having at least one alphabet and 5 numeric value
|
|
|
|
Hi
Please let me help on devlop a VBA macro to Segregate or highlight the cells having at least one alphabet and 5 numeric value for example the cell contains at least value
A12345 or E58932 .please see what type of data I have.
ees-d07483_P
ees-d07484_P
ees-d07692_P
X12470_P3
X12503_P1
N050
...
|
 |
|
|
Thread Tools |
|
#1
12th Jun 2009, 04:02
|
|||
|
|||
|
Segregate or highlight the cells having at least one alphabet and 5 numeric value
Hi
Please let me help on devlop a VBA macro to Segregate or highlight the cells having at least one alphabet and 5 numeric value for example the cell contains at least value A12345 or E58932 .please see what type of data I have. ees-d07483_P ees-d07484_P ees-d07692_P X12470_P3 X12503_P1 N050 N077_buckle N085_tip N079_buckle green color cell I need because it contains one alphabet followed by five nuemeric .i have 80000 cells please help me . |
|
|
|
| Bookmarks |
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro in Excel to print select cells in a worksheet | NothingButProblems | Office Suites & Applications | 0 | 16th Jun 2009 17:12 |
| Thread Tools | |
|
|
