I'm trying to copy a large number amount of data from a table in one workbook into a table on another workbook.
For some reason the code works if I copy and then paste the values:
Workbooks("CaveatorM copy").Sheets("CaveatLists").Range("Table49[[ListDate]:[Current Role]]").Copy
Workbooks("Pre-releaseReports").Sheets("CaveatLists").Range("SavedCaveats[[Date Saved]:[Current Role]]").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
but nothing happens if I try the Range=Range method:
Workbooks("Pre-releaseReports.xlsm").Sheets("CaveatLists").Range("SavedCaveats[[Date Saved]:[Current Role]]").Value = Workbooks("CaveatorM copy.xlsm").Sheets("CaveatLists").Range("Table49[[ListDate]:[Current Role]]").Value
The process is really slow which is why I am trying to speed it up this way, grateful if anyone can spot what I'm doing wrong!
Thanks in advance
Bookmarks