Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post

    PasteSpecial xlPasteValues (Excel 2000 SR1)

    Hi, I've inherited this bit of code:

    Range("P1:V28").Select
    Selection.Copy
    Range("P" & topcellstr).Select
    ActiveSheet.Paste

    And I'd like to change it to xlPasteValues but I can't seem to get the syntax correct, any Ideas?

    Thanks in advance,
    Jim MacLeod
    Shetland Isles

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: PasteSpecial xlPasteValues (Excel 2000 SR1)

    Range("P1:V28").Copy
    Range("P" & topcellstr).PasteSpecial xlPasteValues

    (No need to select cells)

Posting Permissions

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