Copy Row Cells into Stack Paste

[Pinaceous]

Hi All,

I'm trying to Copy row 2's A2 to K2 of Workbook(1) to then stack paste this information in Workbook(2) A7:A16.


Does anyone know how to do this??


Many thanks!

Pinaceous

 

[Fluff]

How about

Sub InsertTranspose()
   Workbooks(2).Sheets(1).Range("A7:A16").Value = _
   Application.Transpose(Workbooks(1).Sheets(1).Range("A2:K2"))
End Sub

 

[RoryA]

Manually, you can simply use Paste Special and Transpose.

 

[Joe4]

Interesting thing though, your source range of A2:K2 is 11 cells, and your destination range of A7:A16 is only 10 cells...

 

[Pinaceous]

Hi Fluff,
Many thanks for posting a code for me to test drive.

Cheers,
Pinaceous

 

[Pinaceous]

Interesting thing though, your source range of A2:K2 is 11 cells, and your destination range of A7:A16 is only 10 cells...

Hi Joe4,

That was my mistake, it should all be in agreement as you would expect.

Cheers!