Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formulas from a contiguous range to a safe place and copy them back later
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formulas from a contiguous range to a safe place and copy the
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 "Lucas Budlong" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formulas from a contiguous range to a safe place and copy them back later
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 "Lucas Budlong" a écrit dans le message de ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
Excel copy formulas using non contiguous range | Excel Discussion (Misc queries) | |||
Advancedfilter copy in place doesn't use criteria range correctly | Excel Programming | |||
Copy a range from different worksheets and place in another worsheet | Excel Programming | |||
Range COPY function - how to copy VALUES and not formulas | Excel Programming |