S
shriil
Hi
I have 20 consecutive rows each having 12 values in 12 consecutive
columns in each row. Now i want to write a procedure where I shall be
copying each row and pasting it on a different row. one at a time.
After the procedure has run thru all the 20 rows, it stops.
For Ex. If I have the following Values, such as
Row 1: 4 30 45 23 34 48....... (20 columns)
Row 2: .......... (20 columns)
........
Row 20: ................(20 columns)
The procedure shall first copy entire Row 1 and paste it in Row 50
Then copy entire Row 2 and paste it in
Row 51
Then Copy entire Row 3 and paste it in
Row 52
.... and so on and so forth until Row 20 is pasted.
Pls Help
I have 20 consecutive rows each having 12 values in 12 consecutive
columns in each row. Now i want to write a procedure where I shall be
copying each row and pasting it on a different row. one at a time.
After the procedure has run thru all the 20 rows, it stops.
For Ex. If I have the following Values, such as
Row 1: 4 30 45 23 34 48....... (20 columns)
Row 2: .......... (20 columns)
........
Row 20: ................(20 columns)
The procedure shall first copy entire Row 1 and paste it in Row 50
Then copy entire Row 2 and paste it in
Row 51
Then Copy entire Row 3 and paste it in
Row 52
.... and so on and so forth until Row 20 is pasted.
Pls Help