I have a form with 3 CommandButtons.
1. "Copy Row" Button
2. "Clear Values" Button
3. "UnDo Row" Button
Here are the Click Actions for each Button:
Private Sub Copy_Row_Click()
' ....???? Selection.EntireRow ....Copy to Memory ???
Private Sub Clear_Values_Click()
Private Sub Undo_Row_Click()
' ....???? Selection.EntireRow ......bring back the old Row....???..
I am trying to find a way so that, when I hit the Button "Copy_Row" and Then Button "Clear Values" to be able (if I decide at a later stage) to bring the entire cleared Row (with its Values and its Formulas) back to place.....
I am not looking for the standard method of copying the whole file because it is very big and it will slow the procedures down....
Thanks in advance,