This is the data all in column A1 to A300

1
2
3
4
5
6
7
8
9
10
11
to 300

I want to create a program to give me the data format as shown below:
for every 30 rows, it will put the data together with a "comma" between
each number:

I like to see how it is written in VB:


1,2,3,4,5,6, to 30
31,32,33, to 60
61, to 90
91,92, to 120
and so on
Can someone help me please?


--
tbobo
------------------------------------------------------------------------
tbobo's Profile: http://www.excelforum.com/member.php...o&userid=31530
View this thread: http://www.excelforum.com/showthread...hreadid=525428