Copy Active Sheet
 

Could someone assist me with a simple VBA that will copy the activesheet to a sheet called "Input" retaining all formats etc?

Thanks

Copy Active Sheet
 

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

Copy Active Sheet
 

2016. október 25., kedd 8:12:23 UTC+2 idÅ‘pontban a következÅ‘t Ã*rta:
Could someone assist me with a simple VBA that will copy the activesheet to a sheet called "Input" retaining all formats etc?

Thanks

You can use ActiveSheet.Copy After:=Sheets(1) to clone the entire worksheet.

Gábor

up cho bạn may mắn