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 pops up.
Regards - Dave
> Date: Wed, 14 Jul 2010 13:04:05 -0700
> Subject: $$Excel-Macros$$ Excel macro undefined variable
> From: ottl...@gmail.com
> To: excel-macros@googlegroups.com
>
> I am looking at a macro in a fairly large multi-tab Excel file. (This
> is not my file, I am validating some economic assumptions that this
> file uses, and I want to see where they end up.) Anyway, I ran across
> this line of code in the macro: "BranchLine = BranchLine + 1". Looking
> back through the macro (and also the other macros in the file) and
> also at the named ranges, I cannot find any previous reference or
> definition for the variable BranchLine. Later in the code, this line
> occurs: "DateLine=Range("D" & BranchLine)". I understand that D refers
> to a column, and BranchLine will tell me the row, but I can find no
> original value for BranchLine. Is there a way to find out the original
> value?
>
> --
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
_________________________________________________________________
Need a new place to live? Find it on Domain.com.au
http://clk.atdmt.com/NMN/go/157631292/direct/01/
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
