apple
07-18-2007, 12:46 AM
Hi,
Please do show me the way to highlight 5 number in front and 5 number at the back. For example the number i want is 12345-ABC-67890.I want to highlight all the number that is 5 number in front, middle got ABC and at the back is 5 number.
Besides that i want highlight the sequence number which is start from 1 to 1.1, 1.1.1, 1.1.2 and so on. After that start loop 2 to 2.2.1,2.2.2, 2.2.3 and so on.
Below is the example:
1.1.0 12345-ABC-647891
1.1.2 67891-DEG-112345
1.1.3 78910-HIJ-123467
2.1.0 65478-KLM-645789
2.2.1 45678-OPQ-489453
I would like to highlight the number follow the sequence for number 1.1.0 to the end 1.1.3 that have 5 number in front, middle ABC and 5 number at the back. After that start loop 2.1.0 until end of 2.2.1
I am new to VBA .Thanks. Hope to hear any friend to help me soon.
Regards,
Apple
Please do show me the way to highlight 5 number in front and 5 number at the back. For example the number i want is 12345-ABC-67890.I want to highlight all the number that is 5 number in front, middle got ABC and at the back is 5 number.
Besides that i want highlight the sequence number which is start from 1 to 1.1, 1.1.1, 1.1.2 and so on. After that start loop 2 to 2.2.1,2.2.2, 2.2.3 and so on.
Below is the example:
1.1.0 12345-ABC-647891
1.1.2 67891-DEG-112345
1.1.3 78910-HIJ-123467
2.1.0 65478-KLM-645789
2.2.1 45678-OPQ-489453
I would like to highlight the number follow the sequence for number 1.1.0 to the end 1.1.3 that have 5 number in front, middle ABC and 5 number at the back. After that start loop 2.1.0 until end of 2.2.1
I am new to VBA .Thanks. Hope to hear any friend to help me soon.
Regards,
Apple