VBA provides a feature that helps you to find all the compile errors usingDebug -> Compile VBAProject. When you use Compile VBAProject, the VBA compiler goes through each line of the code, stops, and shows a dialog when it finds an error. You can correct the error and repeat the steps...