View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Calling Public Variables between diff Modules

You might try changing
for lib to for i

--
Don Guillett Excel MVP
SalesAid Software

"J@Y" wrote in message
...
I declared a public variable "Lib" in Module1. I have a For loop in Module
1
using "Lib" :

For Lib = 1to 10

...(code) ...

Next

In the (code) section, I call Module2. When Module2 calls the Lib
variable,
gives me the ambiguous variable error. Is this because the For statement
actually declares Lib as a procedural variable instead of using it as a
public variable?