Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SIMPLE copy (Excel xp)

    It's been so long since I've touched anything to do with VBA that I can't even think of the best way to do this.

    Very simple, I just want to copy from a range name CURRENT and paste value to a range name PREVIOUS.

    Very easy to record it, but it looks pathetic.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SIMPLE copy (Excel xp)

    Like this:

    Sub test()
    With ThisWorkbook
    .Names("CURRENT").RefersToRange.Copy Destination:=.Names("PREVIOUS").RefersToRange
    End With
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Kent, England
    Posts
    108
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SIMPLE copy (Excel xp)

    Thanks...but just to clarify, I need this to paste-value the range as the cells within CURRENT contain formulas.

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SIMPLE copy (Excel xp)

    Now you tell me <g>.

    Sub test()
    With ThisWorkbook
    .Names("CURRENT").RefersToRange.Copy
    .Names("PREVIOUS").RefersToRange.PasteSpecial Paste:=xlValues
    End With
    End Sub
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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