使用单元格引用复制/粘贴数据(VBA)

I'm trying to copy data from one file into another. First, I'd like to find the last row/column in the source file and use that information to copy the data. However, I can't seem to get the code to copy/paste with the references to the last row and column used. Here's what I currently have:I'm trying to copy data from one file into anot