Global variables

How does one establish global variables?

Ed

Declare them outside of any macro, at the start of a standard module, and
declare them as Public.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" <eenglish@cox.net> wrote in message
news:h16cd2hqk9vldt9imlfguj2hp3shriub74@4ax.com...
> How does one establish global variables?
>
> Ed

Thank you.


On Sun, 6 Aug 2006 18:24:52 +0100, "Bob Phillips"
<bob.NGs@somewhere.com> wrote:

>Declare them outside of any macro, at the start of a standard module, and
>declare them as Public.

Still having problems.

I set up a separate module with the Public variables as integers.

When I try to run the macro I get the message:


Compile error ambiguous name detected: v

Do you have any ideas?




On Sun, 6 Aug 2006 18:24:52 +0100, "Bob Phillips"
<bob.NGs@somewhere.com> wrote:

>Declare them outside of any macro, at the start of a standard module, and
>declare them as Public.

Ed,
That normally means that you have 2 variables/functions etc with the same
name and scope.

NickHK

"Ed" <eenglish@cox.net> wrote in message
news:2nucd2lnj0grsorqeh5t9ll4c8tmn9c3ha@4ax.com...
> Still having problems.
>
> I set up a separate module with the Public variables as integers.
>
> When I try to run the macro I get the message:
>
>
> Compile error ambiguous name detected: v
>
> Do you have any ideas?
>
>
>
>
> On Sun, 6 Aug 2006 18:24:52 +0100, "Bob Phillips"
> <bob.NGs@somewhere.com> wrote:
>
> >Declare them outside of any macro, at the start of a standard module, and
> >declare them as Public.