Excel VBA：如何将数据推送到另一个工作表的独占范围？

I use the sub below as part of another sub which error checks and saves a grade sheet. There will be at least 39 grade sheets generated throughout the course this is built for. Each event may be accomplished more than once - a weather cancel, or student failed.I use the sub below as part of another sub whic