VBA usedrange run-time error 438 object doesn't support this property or method

I am working on a macro involving usedrange. Basically my sub tries to open up a text file with opentext and copy the formulas in the text file and paste over to the worksheet "SOE Summary" of my destination workbook. However, a run-time error 438 would occur when I try to set the formulas of my worksheet "SOE Summary" equal to the formulas in the text file. Any insight would be appreciated.I am working on a macro involving usedrange. Ba