×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Copy Paste special transpose

Excel Copy Paste special transpose

Excel Copy Paste special transpose

(OP)
I would like to know if VBA can help me do a copy then paste special transpose AND maintain the formatting of the paste location.

Thanks,

RE: Excel Copy Paste special transpose

I took this:

      A         B
1  1/1/2018   date
2  Joe        text
3  123        number
4  $12.50     money
 
and with this code:

CODE

Range("A1:A4").Copy
Range("C1").PasteSpecial Paste:=xlPasteAll, _
    Operation:=xlNone, SkipBlanks:= False, Transpose:=True 

I've got his:

        C         D      E        F
1   1/1/2018	Joe	123	$12.50
 


---- Andy

There is a great need for a sarcasm font.

RE: Excel Copy Paste special transpose

(OP)
Thanks. One more thing. Did this leave the target formatting alone? If my paste range has formatting I want it to remain when new information is pasted in. Thanks again.

RE: Excel Copy Paste special transpose

Try this...

CODE

Range("A1:A4").Copy
Range("C1").PasteSpecial Paste:=xlPasteValues, _
    Operation:=xlNone, SkipBlanks:= False, Transpose:=True 

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Excel Copy Paste special transpose

(OP)
I will do this first thing in the morning. I will let you know the results. Thanks Skip

RE: Excel Copy Paste special transpose

(OP)
Skip,
Very nice. This does exactly what I want it to do. Thanks and here is a Star.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close