Forum Discussion
Solved
VBA Code Working
Hi guys, I got this code from https://www.youtube.com/watch?v=jGhkLeHMEUA&list=RDCMUCABOBqS3y8Xn_o7bXvH-j2Q&start_radio=1 and it keeps giving me an error (Run-time error '9': Subscript out of ran...
Does the error appear for i = 13?
Line 66 of the code refers to a worksheet named according to the value in ThisWorkbook.Sheets(sh.cells(2, i).value) which would be ThisWorkbook.Sheets("ATHLONE EXPRESS BLACK") for i = 13.
According to your screenshot there isn't a worksheet named "ATHLONE EXPRESS BLACK" which would explain the error message.
Does the error appear for i = 13?
Line 66 of the code refers to a worksheet named according to the value in ThisWorkbook.Sheets(sh.cells(2, i).value) which would be ThisWorkbook.Sheets("ATHLONE EXPRESS BLACK") for i = 13.
According to your screenshot there isn't a worksheet named "ATHLONE EXPRESS BLACK" which would explain the error message.
- Hi, I actually solved it. I have the other sheet names in my User Management Sheet already without creating the sheets. When I removed them I solved the problem. But thanks. Tried yours and it worked also.
