+ Reply to Thread
Results 1 to 9 of 9

Copy (values only) not ALL using a recorded macro

  1. 04-22-2009, 02:45 PM #1
    Traymond
    Traymond is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Copy (values only) not ALL using a recorded macro

    I have a macro that selects and copies and pastes a range of data from one sheet to another sheet. It works perfectly except it is pasting all the cell formatting and formulas and i only want or need the values. Can someone help ?

    here is the code i am currently using

    Please Login or Register  to view this content.
    Thanks
    Last edited by Traymond; 04-22-2009 at 06:27 PM.
    Reply With QuoteRegister To Reply
  2. 04-22-2009, 02:51 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Copy (values only) not ALL using a recorded macro

    Try something like

    Please Login or Register  to view this content.
    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!
    Reply With QuoteRegister To Reply
  3. 04-22-2009, 03:03 PM #3
    Traymond
    Traymond is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Copy (values only) not ALL using a recorded macro

    tried that it did not like it. got a debug error
    i titled the thread wrong it is not a recorded macro. i added the code
    that i amcurrently using to my original post if that will help you any.
    Thanks
    Reply With QuoteRegister To Reply
  4. 04-22-2009, 03:11 PM #4
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Copy (values only) not ALL using a recorded macro

    Maybe

    Please Login or Register  to view this content.
    VBA Noob
    Reply With QuoteRegister To Reply
  5. 04-22-2009, 03:20 PM #5
    Traymond
    Traymond is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Copy (values only) not ALL using a recorded macro

    I got a sysntax error I copied and pasted your code trying to make sure
    i did not type it in wrong. any other ideas ?
    Reply With QuoteRegister To Reply
  6. 04-22-2009, 03:22 PM #6
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Copy (values only) not ALL using a recorded macro

    Post a sample file please

    VBA Noob
    Reply With QuoteRegister To Reply
  7. 04-22-2009, 03:45 PM #7
    Traymond
    Traymond is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Copy (values only) not ALL using a recorded macro

    on Sort_groups click create groups button Groups tab is where it copies too.

    Macro is named Group_Sheet2 under Sort_Groups

    let me know if you need more info thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 04-22-2009, 03:57 PM #8
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988

    Re: Copy (values only) not ALL using a recorded macro

    I didn't see that macro in the attached workbook.

    Place this in you're module and then press F5 to run. If it works re assign the macro to the button

    Please Login or Register  to view this content.
    VBA Noob
    Reply With QuoteRegister To Reply
  9. 04-22-2009, 06:26 PM #9
    Traymond
    Traymond is offline
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Re: Copy (values only) not ALL using a recorded macro

    That works for me !!! Thanks for the help.
    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)

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