'Search for last empty row in Summary_Receipt_Fees
Worksheets("Print Table").Range("A2").PasteSpecial Paste:=xlPasteValues
First, that comment doesn't seem to match up with the instruction.
Second, when you use the Clear method, it apparently clears the Clip Board.
Try this in a new workbook:
1 - Copy this code into the VBA editor, but don't run it.
Range("A1") = "Hello"
2 - Size the VBA editor window so that you can see the spreadsheet behind it.
3 - Place your cursor inside the code and press F8 (Single Step) 4 times.
4 - Hello should be in A1 and the Copy "bars" should be circling A1.
5 - Right click any cell(s) in the spreadsheet and you can Paste "Hello" wherever you'd like, as often as you'd like.
6 - Go back into the VBA editor and press F8 one more time to execute the .Clear line.
7 - Notice that the Copy bars are gone. Right click in any cell and you'll see that the Paste option is grayed out because the Clip Board is empty.
Annoying, isn't it?
Try this instead of .Clear:
Worksheets("Print Table").Range("A2:L10000") = ""
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.