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
|