VBA Excel - 使用单个变量为数组指定多个值

For my issue i have checked the archive and there is a similar thread but my issue is slightly different and i cant seem to be able to tweak my code to make it work. The similar one is here: For my issue i have checked the archive and the