Results 1 to 9 of 9

Thread: Copy, destination & paste special

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Copy, destination & paste special

    Hi all, is it true that copy, destination and paste special don't work together???
    i'm trying to put them all together in my code but i get errors all the time..... i wanted the code to just paste only the value of copied range(B10:S10) into a single starting cell (A1) instead of using A1:A10.

    My codes:

    Set rng = wb.Worksheets(Sheet1).Range("B10:S10")
    rng.Copy Destination:=Range(A1).PasteSpecial(xlPasteValues
    Thanks you.
    Last edited by Aussiebear; 04-15-2023 at 03:06 AM. Reason: Adjusted the code tags

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •