Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global variables
How does one establish global variables?
Ed |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global variables
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" wrote in message ... How does one establish global variables? Ed |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global variables
Thank you.
On Sun, 6 Aug 2006 18:24:52 +0100, "Bob Phillips" wrote: Declare them outside of any macro, at the start of a standard module, and declare them as Public. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global variables
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" wrote: Declare them outside of any macro, at the start of a standard module, and declare them as Public. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Global variables
Ed,
That normally means that you have 2 variables/functions etc with the same name and scope. NickHK "Ed" wrote in message ... 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" wrote: Declare them outside of any macro, at the start of a standard module, and declare them as Public. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
global variables | Excel Programming | |||
Global Variables | Excel Programming | |||
Global Variables | Excel Programming | |||
global variables | Excel Programming | |||
Global Variables | Excel Programming |