"Pastespecial Method of Range Class Failed" while trying to Transpose

[tenscourts]

Anyone see my problem here? Keep getting a "pastespecial method of range class failed" error. Trying to transpose columns F & G to Rows A1 & A2 on a different sheet.

Please Login or Register  to view this content.

[Pete_UK]

In your last line, make it Range ("A1").

Also, ensure that LastRow is not greater than the number of columns in your sheet (is the file saved as .xlsm or as .xls ?)

Hope this helps.

Pete

[tenscourts]

I changed it to ("A1") and I still get teh error. The sheet "TeamReport" is newly created and it has nothing. It works fine when I manually cut and paste the cells. This particular sheet is an xlsx. The macro is running from an xlsm that is also open. Maybe I'm wrong but I don't see that as being an issue. I feel like I'm missing soemthign with the range or a syntax.

[Cutter]

Can you Paste Special - Values when using Cut????

[tenscourts]

Excellent point! You can't...and I figured that out shortly before your post. I changed it to copy and then used some more code to clear the cells after.