Hi,

ActiveSheet.Range("A1:D4").Copy Sheets("Input").Range("A1")

isabelle

Le 2016-10-25 Ã* 02:12, a écrit :
Could someone assist me with a simple VBA that will copy the activesheet to a sheet called "Input" retaining all formats etc?

Thanks