copy from previous page  
Author Message
cf_rich





PostPosted: 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





PostPosted: 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





PostPosted: 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,
> >
> >
>
>
>