+ Reply to Thread
Results 1 to 7 of 7

Copy Paste Special Values

  1. 01-19-2008, 11:02 AM #1
    Lotus123
    Lotus123 is offline
    Forum Contributor Lotus123's Avatar
    Join Date
    11-07-2005
    Location
    Texas
    MS-Off Ver
    2007
    Posts
    153

    Copy Paste Special Values

    Can someone suggest an alternative to what I'm doing here. I get an error on the "copy/paste values" here...

    Please Login or Register  to view this content.
    Full Code

    Please Login or Register  to view this content.
    Ecce Potestas Casei
    Nathan Head
    Reply With QuoteRegister To Reply
  2. 01-19-2008, 11:08 AM #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
    Maybe

    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. 01-19-2008, 11:11 AM #3
    Lotus123
    Lotus123 is offline
    Forum Contributor Lotus123's Avatar
    Join Date
    11-07-2005
    Location
    Texas
    MS-Off Ver
    2007
    Posts
    153
    "Object doesn't support this property or method" on this line:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 01-19-2008, 11:16 AM #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
    Instead of using Activesheet for both workbook re using the sheet names E.g

    Please Login or Register  to view this content.
    VBA Noob
    Reply With QuoteRegister To Reply
  5. 01-19-2008, 11:20 AM #5
    Lotus123
    Lotus123 is offline
    Forum Contributor Lotus123's Avatar
    Join Date
    11-07-2005
    Location
    Texas
    MS-Off Ver
    2007
    Posts
    153
    Unfortunately, I cannot specify a sheet name because I need the macro to operate on whatever sheet was selected when the macro started. The sheet name can be different each time I run the macro.

    I'm able to get the code to work as follows:
    Please Login or Register  to view this content.
    The above code was from another expert here, and it works great; however, I would prefer to only snag the values and not also the formats.
    Reply With QuoteRegister To Reply
  6. 01-20-2008, 12:56 PM #6
    Charles
    Charles is offline
    Valued Forum Contributor Charles's Avatar
    Join Date
    02-10-2004
    Location
    Biloxi
    MS-Off Ver
    Windows 7, Excel 2003,2007 & Mac2011
    Posts
    845
    Hi,

    Modified code so that it paste values only.

    Please Login or Register  to view this content.
    Charles

    There are other ways to do this, this is but 1 !
    Be Sure you thank those who helped.
    IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
    Reply With QuoteRegister To Reply
  7. 01-21-2008, 02:11 PM #7
    Lotus123
    Lotus123 is offline
    Forum Contributor Lotus123's Avatar
    Join Date
    11-07-2005
    Location
    Texas
    MS-Off Ver
    2007
    Posts
    153
    Perfect - Thank you Charles for all your 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