"Reset" back to initial values

[bunnyball88]

I am creating a dashboard, governed by certain assumptions. I'd like for my customer to be able to change those assumptions (e.g. change the price of the widget to see how that changes the output in the dashboard), and futz around, but then, if they want, be able to "hit a button" and have it re-install the values and / or formulas that formed the initial assumptions.

Is there a way to do that?

Supernew to VBA and macro's so I apologize in advance if this is either very basic or, if upon explanation, i ask for more clarity!

Thank you!

 

[bunnyball88]

Sub ResetConflictMin()
Sheets("Assumptions_Master").Range("AC22:BB46").Copy Destination:=Sheets("Assumptions_Variable").Range("CY22:DX46")
End Sub

Is the fact that i tried (and possibly failed) to name the macro ResetConflictMin the issue?

 

[Jonmo1]

The idea was that the 2 sheets would be 'Identicle', so the copy from address should be the same as the paste to address.

Make sure the Variable sheet isn't protected

 

[bunnyball88]

I dont believe it is protected, or rather, i created the sheet but have added no additional protections. Is there something i have to turn off / opt out of?

Even when i update teh code to:
Sub ResetConflictMin()
Sheets("Assumptions_Master").Range("CY22:DX46").Copy Destination:=Sheets("Assumptions_Variable").Range("CY22:DX46")
End Sub


I get the same error.

Thank you again, for walking me through this so slowly.

 

[Jonmo1]

Sorry, I can't duplicate the error.

I don't see how the name of the macro would make a difference..
You put the code in a Standard Module (Insert - Module - Pasted code there) ?
How are you executing the code? From the Developer tab, macros ?