"Jim Thomlinson" wrote in message
...
"Option Explicit" at the top of your code would have found that for you.
With
it all variables must be explicitly declared. Without it VB will create
new
variables for you on the fly (which is what happened to you). You can set
up
your VB to automatically include option explicit at the top of all of your
new code modules and sheets by selecting tools - Options - General -
Require Variable Declarations.
HTH
SNIP
I thought that I had already done that ... but thanks anyway for your input