Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 73
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 99
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.programming
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
  #4   Report Post  
Junior Member
 
Posts: 3
Default

up cho bạn may mắn
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy sheet and make new sheet active belvy123 Excel Discussion (Misc queries) 5 April 24th 08 03:33 PM
Copy active sheet to new - do no copy buttons Carlee Excel Programming 3 June 13th 07 04:33 PM
Active Cell Copy And Paste Sheet to Sheet A.R.J Allan Jefferys New Users to Excel 4 May 4th 06 02:04 AM
Copy my active sheet to a new sheet and open with an input form Brad Withrow Excel Programming 0 April 6th 06 03:56 AM
Copy from active sheet and paste into new sheet using info from cell in active Ingve Excel Programming 3 January 23rd 06 10:57 PM


All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"