Pedro,
The only thing I can think of is that the variable is misspelled. Do you
have "Option Explicit" at the top of all your code modules? You should,
since the will require that all variable be explicitly declared, and
misspelled variables will be flagged by the compiler.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Pedro" wrote in message
...
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