Hi,
I am trying to copy a range of data
(from row2 ~ to the last row in column C in Sheet1)
and transpose, and paste the values to A1 ~ to the end of the row.
The number of rows and columns vary for each data file and got to this point
Worksheets(1).Range("C2:").Copy
Worksheets(2).Range("A1").PasteSpecial Transpose:=True
where the problem is that I need to select the whole column C
in sheet1 from row 2. Is this possible at all?
Please help me I am stuck.
Thanks in advance.
I am trying to copy a range of data
(from row2 ~ to the last row in column C in Sheet1)
and transpose, and paste the values to A1 ~ to the end of the row.
The number of rows and columns vary for each data file and got to this point
Worksheets(1).Range("C2:").Copy
Worksheets(2).Range("A1").PasteSpecial Transpose:=True
where the problem is that I need to select the whole column C
in sheet1 from row 2. Is this possible at all?
Please help me I am stuck.
Thanks in advance.