copy formulas from a contiguous range to a safe place and copy them back later

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lucas Budlong - 22 Feb 2006 19:54 GMT

Hi,

What I want to do is copy the formulas from a contiguous range on sheet1 to
a safe place (say sheet2) so they can easily be restored later, if someone
mucks them up.

Any assistance at all will be very much appreciated,
Thank you,
LB

Reply to this Message

Toppers - 22 Feb 2006 20:22 GMT

Lucus,

Copies Sheet1 A1:a10 to Sheet2 A1:a10
Sub Copy()
With Worksheets("Sheet1")
.Range("A1:a10").Copy Worksheets("Sheet2").Range("a1")
End With
End Sub

> Hi,
>
[quoted text clipped - 5 lines]
> Thank you,
> LB

Reply to this Message

Ardus Petus - 22 Feb 2006 20:26 GMT

Sub save()
Sheets("sheet1").Range("A5:C8").Copy Sheets("sheet2").Range("A1")
End Sub

Modify sheet name sand ranges according to your needs

HTH

--
AP

> Hi,
>
[quoted text clipped - 5 lines]
> Thank you,
> LB

Reply to this Message