bmba007
11-30-2019, 10:12 PM
In one of my excel files, in a column, there are some numeric values e.g.
VL. No.
2
1
5
3
4
8
11
1
3
In another sheet of that file I want to write the starting range and ending range like this using the data from the above column using VBA:
First NumRange
Last NumRange
1/38
2/38
3/38
3/38
4/38
8/38
9/38
11/38
12/38
15/38
16/38
23/38
24/38
34/38
35/38
35/38
36/38
38/38
The 38 is the sum of all the values from column VL. No. How can I achieve this using VBA?
Thanks:)
VL. No.
2
1
5
3
4
8
11
1
3
In another sheet of that file I want to write the starting range and ending range like this using the data from the above column using VBA:
First NumRange
Last NumRange
1/38
2/38
3/38
3/38
4/38
8/38
9/38
11/38
12/38
15/38
16/38
23/38
24/38
34/38
35/38
35/38
36/38
38/38
The 38 is the sum of all the values from column VL. No. How can I achieve this using VBA?
Thanks:)