Unknown error in my macro

Thank you for the quick response however when I changed that I have received the error "run time error '9': subscript out of range

I think it is because the top part of the sheet and the bottom part of the sheet is locked so the only rows that can be edited are b11:b63. I didn't think that would be important however it appears for this solution it is.