If you wanted to copy a range from Sheet1!J:J of the original workbook, to Sheet2!M:M of all the other closed workbooks, you'd call the function by doing this.
Code:Sub TCall() CopyAndPasteToMultipleWorkbooks "Sheet1", "J:J", "Sheet2", "M:M" End Sub
Bookmarks