I am declaring it in the standard module



"Chip Pearson" wrote in message
...
Pedro,

Are you declaring the variable in a standard code module, rather than a
sheet's code module or a form or ThisWorkbook?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Pedro" wrote in message
...
Hi
I have declares as a Public variable strNumber doing:
Public strNumber as variant
when the code opens runs other module in a different worksheet the
variable
is empty

how to solve it?
thanks
Pedro

ps. Chip thanks for all your help

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