copy from previous page

[Myriam]

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,

[Tom Ogilvy]

activesheet.previous.Range("A1:b5").Copy ActiveSheet.Range("A1:B5")

--
Regards,
Tom Ogilvy


"Myriam" <[email protected]> wrote in message
news:[email protected]...
> 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]

Thanks!

"Tom Ogilvy" wrote:

> activesheet.previous.Range("A1:b5").Copy ActiveSheet.Range("A1:B5")
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Myriam" <[email protected]> wrote in message
> news:[email protected]...
> > 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,
> >
> >
>
>
>