+ Reply to Thread
Results 1 to 4 of 4

Need macro to paste link, not values

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    Colorado
    MS-Off Ver
    2010
    Posts
    17

    Need macro to paste link, not values

    I'm trying to use a formula to copy and paste between workbooks, it does everything fine except it pasting the data as values. I need the data to be able to be updated automatically.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Need macro to paste link, not values

    Hi,

    Record a macro that uses the Paste Link function from the Paste Special dialog box and see what the code looks like.
    http://www.msoffice-tutorial-trainin...e-special.html

    I'm not sure 2003 Excel had this "Paste Link" feature or not.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    Colorado
    MS-Off Ver
    2010
    Posts
    17

    Re: Need macro to paste link, not values

    I've tried that it says ActiveSheet.Paste Link:=True, tried it and i get Run time error 1004 paste method of worksheet class failed when I try using it.

  4. #4
    Registered User
    Join Date
    12-07-2012
    Location
    Colorado
    MS-Off Ver
    2010
    Posts
    17

    Re: Need macro to paste link, not values

    This is what I'm using to copy over
    Sub SelectRange()
    Dim r As Range
    On Error Resume Next
    Set r = Application.InputBox(prompt:="Enter a Range", Type:=8)
    On Error GoTo 0
    If r Is Nothing Then Exit Sub
    Workbooks.Open "S:\QA\Josh\CRI Temp.xlsx"
    r.Copy Destination:=Sheets("CRI Form").Range("A2")
    Range("A2").Select

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1