I have a worksheet where a user clicks on a button and a macro runs which adjust a 12 month range of data to incorporate the new month. I have an undo button that returns the month range and associated data back to its state before the adjust range button was first clicked.
What I want to do is to accomplish this using an array.
This is what would need to happen:
Macro button 1:
Cells c20 through c34 need to be read into an array.
Macro button 2:
This array then needs to be read and the contents restored to cells c20 through c34.
How can I accomplish this?
Thanks.
What I want to do is to accomplish this using an array.
This is what would need to happen:
Macro button 1:
Cells c20 through c34 need to be read into an array.
Macro button 2:
This array then needs to be read and the contents restored to cells c20 through c34.
How can I accomplish this?
Thanks.