Help with transposing from Column to Row!

[LostinVA]

Hi everybody.. I'm looking for help to update the below code to transpose data from Column format to Row format. I have the below code (thanks @Yongle for your help!) that copy values in a set of column cells when a button is pressed and pastes those values onto another tab. If the user changes any of the values that were copied and pasted previously and the button is pressed again, the data is again copied but then pasted on the next row BELOW where the previous data was pasted. Currently the copied data is pasted in column format. I'm trying to transpose the data so it's pasted in row format instead of column format. Seems as though it would only take a minor tweak to the below code but I'm a complete noob and can't get it to work. I tried using 'Transpose:=True' but am getting errors.

Private Sub CommandButton1_Click()
Range("C2:C25").Copy Sheets("OtherTab").Range("A" & Rows.Count).End(xlUp).Offset(1)
End Sub

Appreciate any help you can provide!

 

[Fluff]

How about

Private Sub CommandButton1_Click()
Range("C2:C25").Copy
Sheets("OtherTab").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Transpose:=True
End Sub

 

[LostinVA]

Thanks for your quick reply! It's giving me a Compile Error: Syntax error?

Private Sub CommandButton1_Click()
Range("C2:C25").Copy Sheets("OtherTab").Range("A" & Rows.Count).End(xlUp).Offset(1).PasteSpecial Transpose:=True
End Sub

 

[Fluff]

It needs to be on two lines, as I showed

 

[LostinVA]

Perfect, thank you! I had no idea that would make a difference but I also am a complete noobie so not surprising.. haha

I really appreciate your help!

 

[Fluff]

Glad to help & thanks for the feedback