declare in standard code module
Global Myvar as ...
rather than Public or Dim



"Pedro" a écrit dans le message de
...
I am declaring it in the standard module


[...]

Pedro

ps. Chip thanks for all your help