Error 424 Object Required When attempting to use ActiveCell in VBA

I work in education and I am trying to automatically allocate students to subject choices based on two defining factors: CLV (Curriculum Level) and their term of enrolment. I have coded the VBA using a series of if then else statements which I want to be triggered by the selection of a variable from a data validation list to write values in the appropriate corresponding cells (using activecell.offset). My first VBA coding test only required one "if" dependent on the activecell and it worked and was triggered directly from within the VBA editor as I was unsure of how to get it to trigger from the data validation list selection. As soon as I attempted to put in two other variables offset from the activecell using "And" commands, however, it returned an "Error 424 Object Required" statement and I'm not sure why. I have included a link to the workbook. Any help appreciated! Curriculum Variations File