+ Reply to Thread
Results 1 to 9 of 9

macro for paste values and transpose

  1. #1
    Registered User
    Join Date
    07-13-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    20

    macro for paste values and transpose

    Hi Everyone,

    I'm looking for a macro that will allow me to past values and transpose.
    I tired recording, but the macro receives errors.

    Thank You

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: macro for paste values and transpose

    Hi, svinet,

    any additional information about what range you want to copy/transpose would be welcome as well as either the recorded code or the error message which might helkp in solving your problem. You might even consider attaching a sample workbook with situation as is and as wanted.

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Registered User
    Join Date
    02-20-2014
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    87

    Re: macro for paste values and transpose

    Edit this with your range to copy and paste:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-13-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    20

    Re: macro for paste values and transpose

    I would like to use the macro to only paste the values that I have already manually copied.

  5. #5
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: macro for paste values and transpose

    Quote Originally Posted by svinet View Post
    I have already manually copied.
    * from where.. is it from any other application..
    * Is Alt + E + S + E + V working.. Manually

    Please elaborate.. briefly..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  6. #6
    Registered User
    Join Date
    07-13-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    20

    Re: macro for paste values and transpose

    This would be from excel.
    Alt + E + S + E + V works fine, but I want to make a button on my ribbon to complete the action for me.

  7. #7
    Registered User
    Join Date
    07-13-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    20

    Re: macro for paste values and transpose

    Quote Originally Posted by Debraj Roy View Post
    * from where.. is it from any other application..
    * Is Alt + E + S + E + V working.. Manually

    Please elaborate.. briefly..
    This would be from excel.
    Alt + E + S + E + V works fine, but I want to make a button on my ribbon to complete the action for me.

  8. #8
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: macro for paste values and transpose

    Please Login or Register  to view this content.
    Try this..

  9. #9
    Registered User
    Join Date
    07-13-2014
    Location
    Toronto, Canada
    MS-Off Ver
    2010
    Posts
    20

    Re: macro for paste values and transpose

    Quote Originally Posted by Debraj Roy View Post
    Please Login or Register  to view this content.
    Try this..
    Worked perfect
    i was missing the Activecell.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Paste Special - Values, Transpose Need Icon
    By Zimmerray1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-12-2014, 04:34 PM
  2. [SOLVED] Excel 2010 - Paste Values with Paste Transpose at the same time
    By phillyfilly in forum Excel General
    Replies: 3
    Last Post: 11-05-2013, 04:23 AM
  3. Unique Values, Paste and Transpose
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-09-2011, 04:22 PM
  4. Macro for copy paste values transpose
    By straggleyway in forum Excel General
    Replies: 0
    Last Post: 03-11-2009, 07:32 AM
  5. [SOLVED] Paste Special - Values - Transpose
    By J in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-06-2005, 12:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1