VBA code troubleshooting (error fixing)

Job ID: 36261504

Budget: $10 – $30 USD

Have a code that throws an error message while its doing a while do loop. Just need a VBA code expert to resolve this. After that, there will be other subsequent work related to VBA coding.
Related categories: Excel VBA Excel Macros