Consulting

Results 1 to 6 of 6

Thread: VBA PasteSpecial error

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 08-15-2019, 02:03 AM #1
    malleshg24
    malleshg24 is offline
    Banned VBAX Contributor
    Joined
    Aug 2017
    Posts
    144
    Location

    VBA PasteSpecial error

    Hi Team,


    I need your help in understanding paste special , why it throws error when we write in a single line.


    This throws copile error at xlPasteValues
    Sheet1.Range("A1").CurrentRegion.Copy Sheet2.Range("A1").PasteSpecial xlPasteValues

    This works
    Sheet1.Range("A1").CurrentRegion.Copy
Sheet2.Range("A1").PasteSpecial xlPasteValues



    Regards,
    mg
    Last edited by Bob Phillips; 08-15-2019 at 04:47 AM. Reason: Legibility
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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