Thread: Copy Active Sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] szentkatg@gmail.com is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote