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