I've never had any trouble with common local and global names (but I do try to
avoid that).

Any chance you have multiple procedures using that same sub/function name?

How about the module name? I wouldn't use a sub/function name for the module
name, either.

Zone wrote:

Jim, I always use the Option Explicit. If I declare a local variable
with the same name as a global variable (including capitalization), I
get this message. Gosh, am I wrong about this?
James

--

Dave Peterson