Sequential Checker

Hi,
Would like to seek for help regarding excel macro that I am using.
This code is for development and needs some editing but I was not much familiar with the codes used as I only know more on recording scripts.

Please Login or Register  to view this content.

Data that can be used as sample are:
Cell A1 - ES10001
Cell A2 - ES10002
Cell A3 - ES10003
Cell A4 - ES10004-ES10006
Cell A5 - ES10007 - 08 - 09 - 10
Cell A6 - ES10011
Cell A7 - DCY10001 DEN 90 E KADAR
Cell A8 - DT40000

For the samples above, Cell A1-A6 are in a sequence, and just like in the code above, Cell A4 and Cell A5 would be seperated by inserting another rows and putting the values in order. Cell A4 means ES10004, ES10005 & ES10006. Cell A5 means ES10007-ES10010.
Cell A7 is same scenario. That kind of format means DCY10001 to DCY10090 (DCY10001 DEN 90 E KADAR or DCY10001 till 90).
In Cell A8, there is no succeeding sequence. This is an error that must be detected by macro code, making the counter value in Cell B8 with text as "out of order". In simple words, when a value is not in sequence, it is automatically an error


1. Need help o label this codes for me to understand how it works
2. The codes are not detecting those inserted values. Like if in the sequence of ES10001-04 then ES10006, you add ES10005 to the sequence. Would like the macro to mark this one as added/inserted values like writing in the column C the text "added values".
3. Would like to know how to disable # 2 (macro would not insert missing values). Guess it would be solved when codes are labelled.
4. Need to have another code when there are values with no sequence. Like in Cell A8, DT40000, there are no more sequence following it.

Many thanks in advance!

P.S Have also post this one on below link:
http://forums.techguy.org/business-a...ml#post8169568