Thank you for your answer, but I can't get it to work. Assume I do not know anything, because I practically do not. When I pasted it, the Sub MakeCopy() turned red, and the button did nothing once I clicked on it. So, what am I missing?
In this case, you've named the macro MakeCopy rather than the name of the command button. You can name your macros anything you want, it doesn't matter. Giving them
descriptive names provides a means of understanding what the macro does without having to test it or read all the way through the lines of code in the macro.
Here is a ridiculous example : Sub ThisMacroCopiesCellsA1nB1toColumnHCell16 ()
A better way of doing the same thing is to use the second macro name above and put a comment inside the macro like this :
Sub MakeCopy ()
'This macro copies data from A1:B1 and pastes to H16
macro code here