Copying and pasting cell values and cell formats

[LAVA2]

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

[alansidman]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread:https://www.excelforum.com/excel-programming-vba-macros/1316406-copying-and-pastiing-cell-values.html