Need to copy Data from Worksheet 1 to Worksheet 2 using VBA

[seethepuck]

I am missing some critical piece of info in my attempt to code this (what I thought would be) an easy task. On a sheet called "Blank Sheet" I have a command button. When that button is clicked, I need to copy the information in Range K2:O10 and paste the values and formatting into worksheet called "Timings Summary" at a location LRow. I made two attempts and neither worked. Can someone review the code below and assist me in finding the error of my ways here. NOTE: for this example I have included both Attempts in the same code. I realize that 1 or the other would be modified but both would not be required.

Please Login or Register  to view this content.

Thanks for your time.

[seethepuck]

The workbook I am using is here.Timings Data ModelTEST.xlsm

[AB33]

I have moved the code from sheet to a module.

[seethepuck]

AB33 - Thanks for the assist. You solution corrected the problem and I appreciate you cleaning up my code a bit. I will take these pointers for future reference as well. Thanks again.