i got
1
1
2
2
3
3
4
4
and i want them to become
1
2
3
1
2
3
4
5
6
4
5
6
7
8
9
7
8
9
10
11
12
10
11
12
ie
1 expands to 1 2 3
2 expands to 4 5 6
3 expands to 7 8 9
4 expands to 10 11 12
pls help
i got
1
1
2
2
3
3
4
4
and i want them to become
1
2
3
1
2
3
4
5
6
4
5
6
7
8
9
7
8
9
10
11
12
10
11
12
ie
1 expands to 1 2 3
2 expands to 4 5 6
3 expands to 7 8 9
4 expands to 10 11 12
pls help
Here you go.
![]()
Please Login or Register to view this content.
---------------------------------------------------
ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
To insert code into the VBE (Visual Basic Editor)
- Copy the code.
- Open workbook to paste code into.
- Right click any worksheet tab, select View Code
- VBE (Visual Basic Editor) opens to that sheets object
- You may change to another sheets object or the This Workbook object by double clicking it in the Project window
- In the blank space below the word "General" paste the copied code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks