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