1. Why are there errors?

1.1. The code is written without too much 'Negative Testing' therefore it assumes the user knows what they are doing.

1.2. Excel is a third party supplier and from time to time Microsoft make enhancements which could potentially cause the software to fail, see this example.

1.3. I have tried to trap errors and where known give a solution to fix the error.

1.4. Clicking on the 'Help' icon will display this page.

1.5. Clicking on the 'Email' icon will open 'Outlook'.

1.5. The following are potential error messages and a solutions:

a. Issue - Run-time error '1004'

Run time error 1004

b. Solution - Prerequisite not set