Test

[Molly Brennholz]

From last post

 _____ Workbook: Merge2.xls ( Using Excel 2007 32 bit )
Row\Col
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R

1
Symbol




=
arrS3(1)

arrS3(1)(1, UBound(arrS3(1), 2)) =


Symbol







2
ACC
1
2
3

=

arrS3(2)


arrS3(2)(1, UBound(arrS3(2), 2)) =


3





3
ADANIENT
1



=


arrS3(2)



arrS3(3)(1, UBound(arrS3(3), 2)) =


1



4



















5



















6



















7

remark I have puuted 1 bcoz series start with 1

















8

and next time when I will run the macro

















9

then it will start with 2

















10

and again when I will ran the macro then it will start with 3

















11



















12







arrS3()=
{ arrS3(1) ,
arrS3(2) ,
arrS3(3)  }








13



















14



















15



















16



















17



















18



















19



















20








arrS3(cnt)(1, UBound(arrS3(cnt), 2)) =










21



















22




















Worksheet: Sheet3 (2)

_____ Workbook: Merge2.xls ( Using Excel 2007 32 bit )

Row\Col	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Symbol					=	arrS3(1)		arrS3(1)(1, UBound(arrS3(1), 2)) =			Symbol
2	ACC	1	2	3		=		arrS3(2)			arrS3(2)(1, UBound(arrS3(2), 2)) =			3
3	ADANIENT	1				=			arrS3(2)				arrS3(3)(1, UBound(arrS3(3), 2)) =			1
4
5
6
7		remark I have puuted 1 bcoz series start with 1
8		and next time when I will run the macro
9		then it will start with 2
10		and again when I will ran the macro then it will start with 3
11
12								arrS3()=	{ arrS3(1) ,	arrS3(2) ,	arrS3(3) }
13
14
15
16
17
18
19
20									arrS3(cnt)(1, UBound(arrS3(cnt), 2)) =
21
22

Worksheet: Sheet3 (2)