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.
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.
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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks