View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default 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