-
Highlight number
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
-
Hi Apple
This is not the correct forum. Is this an Excel or Word question?
Regards
MD
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
Hi,
Please close this issue. Thanks
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules