"Jim Thomlinson" <JimThomlinson@discussions.microsoft.com> wrote in message
news:16F52936-07B4-4172-AE6F-4B03AF9617E0@microsoft.com...
> "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