Help with a Macro

[ROSER72]

Hi,

I am a newbie to VB therefore I would appreciate some help with a macro.

Provided a table that looks like this:
1
2
3
4
9
10
11
12
13

I would like to have the results presented like this:
1-4,9,10-13

I would like to have a list input and have as a result a number grouping of consecutuve numbers.

Regards,
Roser72

 

[PHV]

1-4,9,10-13
Why not this ?
1-4,9-13

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ROSER72]

Sorry I meant

1
2
3
4
7
9
10
11
12
13

to

1-4,7,9-13

 

[PHV]

So, what have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ROSER72]

Have not tried anything don't know where to start

 

[PHV]

Just to know, which Application ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ROSER72]

Excel. I'm importing a list of numbers from a terminal which I need to compare to another list. The list from which I compare it from is already grouped. By doing a macro that groups it I would be able to compare the two list quicker.