Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109471 > unrolled thread

Copy Active Sheet

Back to article view | Back to microsoft.public.excel.programming

Contents

  Copy Active Sheet seanryanie@yahoo.co.uk - 2016-10-24 23:12 -0700
    Re: Copy Active Sheet isabelle <i@v.invalid> - 2016-10-25 12:42 -0400
    Re: Copy Active Sheet szentkatg@gmail.com - 2016-11-01 10:41 -0700
    Re: Copy Active Sheet tinhdauhcm1 <tinhdauhcm1@gmail.com> - 2016-11-02 15:32 +0000

#109471 — 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

[toc] | [next] | [standalone]

#109474

Hi,

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

isabelle

Le 2016-10-25 à 02:12, seanryanie@yahoo.co.uk 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
>

[toc] | [prev] | [next] | [standalone]

#109508

2016. október 25., kedd 8:12:23 UTC+2 időpontban seanr...@yahoo.co.uk 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

[toc] | [prev] | [next] | [standalone]

#109514

up cho bạn may mắn




-- 
tinhdauhcm1

[toc] | [prev] | [standalone]

Back to top | Article view | microsoft.public.excel.programming

csiph-web