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

"Pedro" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>

I am declaring it in the standard module



"Chip Pearson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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
> >
> >
>
>