Table Array Not Working

[majime01]

I have a section of VBA code that is suppose to search an array and execute if table value is TRUE. What is suppose to occur is: user selects from dropdown list on Worksheet "Multiples" and presses "Enter" button on sheet and all students selected with checkbox will have the contents of F6 transferred to their respective sheets (Student 1, Student 2, etc.) When I execute the code it throws an error. I have attached the file to make it easier to understand. Any help is appreciated and an explanation of where I went wrong would be amazing. Thank you.

Please Login or Register  to view this content.

[TMS]

What's Mid(ws.Name, 1) going to give you? A number? Should it be Right(ws.Name, 1)?


Regards, TMS

[majime01]

Thank you TMS, that does work. Any chance you can explain what that line does? I am trying to learn from my mistakes.

[TMS]

Have a look at this link: How to use the left, right, mid, and len functions in Visual Basic for Applications in Excel


Regards, TMS