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" <[email protected]> wrote in message
news:[email protected]...
> How does one establish global variables?
>
> Ed

Thank you.


On Sun, 6 Aug 2006 18:24:52 +0100, "Bob Phillips"
<[email protected]> 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"
<[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
> 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"
> <[email protected]> wrote:
>
> >Declare them outside of any macro, at the start of a standard module, and
> >declare them as Public.