The following isn't dynamically finding where to paste the content from MODELS but it might be a start- you'd need to find the dynamic equivalent of C1 as the intended destination:
Sheets("MODELS").Range("D6:D489").Copy Sheets("PAST").Range("C1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False
Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.
The value in C1 has the location. As the location changes so does the value in C1. This is the reason I was doing it this way.
In the above script would the macro just paste the contents into C1?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks