DEclaring variables

  • Thread starter Thread starter Pedro
  • Start date Start date
P

Pedro

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
 
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
 
I am declaring it in the standard module



Chip Pearson said:
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
Click to expand...
 
Back
Top