The behavior could be explained if there are fewer than 10 rows in "June 2017 SL Fees". If you run the code directly from the VBA editor and it still doesn't do anything, the problem is not with your button. Also see if the code is even trying to run--as a quick diagnostic I suggest putting this line just before the For statement:

MsgBox "lastrow=" & lastrow
If the message box doesn't appear then your code is not even running. But if it does appear, the problem will likely be evident in the message.