Hi,
I would like to request for some assistance in two tasks. First is to copy the cell values and formats from a workbook and secondly paste the cell values along with the formats into another workbook.
For example the code should be able to copy the cell values from workbook C:\CALS\FIRST RUNNER.xlsm, the cell values are in the range AD2:AG16 of sheet1(2). And secondly the code
should be able to paste those cell values along with the formats into Sheet1 of workbook C:\CALS\RUNNER.xlsm where the range for pasting the values and the formats is A2:D16.
Thanks
Bookmarks