|
|
#1
12th Jun 2009, 04:02
|
|||
|
|||
|
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 . |
