For summing up, what I need is to do the opposite of this post:

[How to create a list from beginning number and end number](https://stackoverflow.com/questions/635800/how-to-create-a-list-from-beginning-number-and-end-number)

In other words I have a list of numbers in Column A and I wish to group them up in ranges from beginning to end numbers in columns B and C
i.e.

```
column A
1
2
3
6
7
8
25
28
29
30

```

(after executing VBA code)

```
Column B  Column C
   1         3
   6         8
   25        25
   28        30

```

In case the value cannot be grouped, it will be the same beginning and end number (as seen with N° 25 in above example)