Issues transposing a range

[FZappa]

Hello all, I keep getting an error when trying to copy a range from one sheet and using pastespecial to transpose to another sheet. This is what I have:

Please Login or Register  to view this content.

This is the exact code I'm using for another function, except that I'm not transposing, I'm simply pasting. The error I'm getting is "Expected Funcion or Variable" so I figure I must be doing something fundamentally wrong here. Any insight would be appreciated.

[alansidman]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[FZappa]

Hi, thanks for the reply. It's really quite simple and I've included a sample workbook to show basically what I want to do.

[alansidman]

I would do this using Power Query which is part of your Excel 2013. Here is the Mcode. No VBA required. One simple step after importing to PQ. See my signature for info on PQ

Please Login or Register  to view this content.

[FZappa]

Thanks for the reply. Part of the issue is that I want this to be part of a larger macro that other people are going to end up using (I've also never heard of Power Query so I wouldn't know how to adapt it to the larger project). If it was just me that needed to transpose it I'd probably be happy using that but in the end I need to have a big button that does everything and hopefully doesn't require me to teach people any features of excel for it to work.

[jindon]

Simply

Please Login or Register  to view this content.

[alansidman]

Suggest that you look at the links in my signature to learn about Power Query and the advantages it offers to Excel users. It is the new way of data manipulation in Spreadsheets. I understand your need for VBA in this situation, but PQ is very powerful.

[FZappa]

Hey, I tried your method and it certainly worked, and I managed to make it work for the larger project I'm working with. However, is there a reason why it doesn't work with just "paste"? For example:

Please Login or Register  to view this content.

Just interesting, it gives me a 438 error when I try it.

And thanks for the advice, alanisdman, I'll certainly look it up.

[jindon]

Range object doesn't have Paste method.