Hi all,

so basically what i want is for example there this closed workbook in C:\Users\Kevin\Google Drive\Work\formula.xlsm named "Sheet1", I want to copy the contents of Range("A:Z10") in that closed workbook to the open workbook with all the formulas intact?