Please help with the following...
Using a command button, I would like to have a macro copy the entire row of a selected cell, including formulas, insert the new row directly above the selected cell and clear the contents(not the formula). I also need a message box to prompt the user if they wish to proceed with adding the new row....msg "Add new Row?", if yes then run macro, if no then exit.
New to VB, Any help is Greatly Appreciated!