|
|
|
Author |
Message |
cf_rich
|
Posted: Mon Dec 12 15:35:43 CST 2005 |
Top |
Excel Programming >> copy from previous page
I have a workbook with 20 sheets and I need to write a macro that will copy a
range from the previous page using a command button.
Example: CmdButton1= copy range Sheet1!A1:B5 into Sheet2!A1:B5, Cmd
Button2= copy Sheet2!A1:B5 into Sheet3!A1:B5, etc. I was writing an
individual macro for each sheet but there must be a more efficient way to do
it. Is there a "copy previous page range" into ActiveSheet?
Thanks a million for any help you can give me.
Regards,
Excel126
|
|
|
|
|
Tom
|
Posted: Mon Dec 12 15:35:43 CST 2005 |
Top |
Excel Programming >> copy from previous page
activesheet.previous.Range("A1:b5").Copy ActiveSheet.Range("A1:B5")
--
Regards,
Tom Ogilvy
> I have a workbook with 20 sheets and I need to write a macro that will
copy a
> range from the previous page using a command button.
> Example: CmdButton1= copy range Sheet1!A1:B5 into Sheet2!A1:B5, Cmd
> Button2= copy Sheet2!A1:B5 into Sheet3!A1:B5, etc. I was writing an
> individual macro for each sheet but there must be a more efficient way to
do
> it. Is there a "copy previous page range" into ActiveSheet?
> Thanks a million for any help you can give me.
> Regards,
>
>
|
|
|
|
|
Myriam
|
Posted: Mon Dec 12 16:05:04 CST 2005 |
Top |
Excel Programming >> copy from previous page
Thanks!
> activesheet.previous.Range("A1:b5").Copy ActiveSheet.Range("A1:B5")
>
> --
> Regards,
> Tom Ogilvy
>
>
> > I have a workbook with 20 sheets and I need to write a macro that will
> copy a
> > range from the previous page using a command button.
> > Example: CmdButton1= copy range Sheet1!A1:B5 into Sheet2!A1:B5, Cmd
> > Button2= copy Sheet2!A1:B5 into Sheet3!A1:B5, etc. I was writing an
> > individual macro for each sheet but there must be a more efficient way to
> do
> > it. Is there a "copy previous page range" into ActiveSheet?
> > Thanks a million for any help you can give me.
> > Regards,
> >
> >
>
>
>
|
|
|
|
|
|
|