Yes, I think you're right about variables being zero by default.
Dave.
> Date: Fri, 16 Jul 2010 12:37:57 -0700
> Subject: Re: $$Excel-Macros$$ Excel macro undefined variable
> From: ottl...@gmail.com
> To: excel-macros@googlegroups.com
>
> Thanks. The Find option
Thanks. The Find option did not show any prior instances of the
variable occurring. The MsgBox idea gave me an error when I ran the
macro. I did find that in the Debug menu there are two things that
helped: "Add watch" gives an indicator when the value changes. When
running the macro, the firs
Hi,
Two things I can think of.
1. In the VBA editor, you will see an Edit menu, in which is a Find option.
Enter BranchLine into that and see if it finds something you've missed.
2. Put a message box just before the first mention you can find of BranchLine:
Msgbox = BranchLine
and see what p
