By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 589 - err <> 1004 and Error <> 40040

The error 1004 is pretty common and you can see it by selecting a range name that doesn't exist.

The 40040 is a strange error, not sure of its cause, but I've had to include logic to ignore the error.

See VBA 40040 error