I noticed that you used codenames for the worksheet objects (Static and Live). As far as I'm aware, you shouldn't be able to use the code name "Static" as a codename for a worksheet.
I ran your code, with a small adjustment for the use "Static" to refer to the worksheet name instead and it seems to be working on my end. Not too sure what's going on on your version. Are you able to send the original Excel file (with any important data removed of course) for us to play with?
The code I used for my testing as below:
Bookmarks