+ Reply to Thread
Results 1 to 3 of 3

column E copy/paste special values

Hybrid View

  1. 08-14-2015, 05:55 PM #1
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    column E copy/paste special values

    Hello. How do you copy column E, and paste special values over itself?
    Reply With QuoteRegister To Reply
  2. 08-14-2015, 06:00 PM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,357

    Re: column E copy/paste special values

    1) Select column E
    2) ctrl-C
    3) Home->Paste->as Values
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 08-14-2015, 06:03 PM #3
    YasserKhalil
    YasserKhalil is offline
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: column E copy/paste special values

    Try this
    Sub Test()
    Columns("E:E").Copy: Columns("E:E").PasteSpecial xlPasteValues
    Application.CutCopyMode = False
End Sub
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy rows with values in column H and paste special in different sheet
    By Vikas Singhal in forum Excel General
    Replies: 2
    Last Post: 03-18-2015, 05:31 AM
  2. copy formula and paste for new data added and autofill.....and paste special values
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-13-2014, 07:40 AM
  3. Macro to detect text ‘Current Month’ and then copy column and then paste special values
    By robertguy in forum Excel General
    Replies: 0
    Last Post: 09-18-2012, 11:47 AM
  4. [SOLVED] Macro to find SKU in column; then copy data in row and paste special (values)
    By Starkey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2012, 06:05 AM
  5. Macro to copy and paste special values for column data and filter column data
    By ascottbag in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-10-2012, 02:15 PM
  6. Copy Paste Special Values
    By Lotus123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2008, 02:11 PM
  7. Copy Paste Special Values
    By Brian Matlack in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 01:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1