I need a macro that will reset values in particular cells (C7:C12) with the values in another set of sells (E7:E12) when the Reset Button is pushed. I would use a formula but the values in the C cells may change until reset is fired.
Also, is there a way to list a set of ranges in one line of code? I usually write numerous lines when I have cells in a group (not using Naming conventions) and it would be helpful to know how to list a string of cell references in one line of code.
Thank you in advance,