+ Reply to Thread
Results 1 to 4 of 4

Issue with copy and paste: Run-time error 438

  1. 11-07-2013, 12:06 PM #1
    tariq2
    tariq2 is offline
    Registered User
    Join Date
    10-09-2013
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Issue with copy and paste: Run-time error 438

    Hi,

    I am trying to copy a region from one worksheet to another.
    I receive the following error: 'Run-time error ‘438’:
    Object doesn’t support this property or method'
    This message relates to the last line of code below...



    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-07-2013, 12:16 PM #2
    ragulduy
    ragulduy is offline
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Issue with copy and paste: Run-time error 438

    use .pastespecial not .paste
    Reply With QuoteRegister To Reply
  3. 11-07-2013, 12:20 PM #3
    Norie
    Norie is offline
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Issue with copy and paste: Run-time error 438

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.
    Reply With QuoteRegister To Reply
  4. 11-07-2013, 01:01 PM #4
    tariq2
    tariq2 is offline
    Registered User
    Join Date
    10-09-2013
    Location
    London,England
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Issue with copy and paste: Run-time error 438

    Thank you both for your replies - works a treat...
    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. [SOLVED] COPY/PASTE Issue!!!
    By JamesGoulding85 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-11-2013, 07:47 AM
  2. Copy-Paste cells from from 1 workbook to another: Run-time error '438'
    By Mon1aa in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-05-2012, 02:47 PM
  3. copy and paste issue
    By dude2007 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-19-2008, 05:29 PM
  4. [SOLVED] Copy and Paste Issue
    By Kent Smith in forum Excel General
    Replies: 4
    Last Post: 02-08-2006, 07:20 PM
  5. copy/paste issue
    By butters14 in forum Excel General
    Replies: 0
    Last Post: 02-15-2005, 11:04 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