I am getting an error on this. The code and also the trouble area is posted. What I did is copy a column of data, went to the bottom right cell of a table, hit tab to add new row, then paste special, paste as values and transpose. The error message is PasteSpecial method of Range class failed. How can this be corrected?
Please Login or Register to view this content.Please Login or Register to view this content.
It seems to work when you insert the row before pasting transposed values, so try that first.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks