1. Option Explicit will catch any misspelled variables.
You could think you are referring to one thing and Excel
could be seeing it as something else... lngNum vs. 1ngNum for instance.
2. It will also force you to declare all of your variables.
Undeclared variables become Variants, not always a good thing.
Also, make sure you compile the project before trying to run your code.
That can also point out problems...Debug | Compile VBAProject.

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Dom" wrote in message
...
Jim Cone wrote:

Does the workbook function on your computer but not on other computers?

No... The same error occurs on whatever computer I run it on.
What does the "Option Explicit" actually do?

Thanks for the pointer - I'll give it a try on Monday!