I have multiple Vlookup that are run by a MACRO. I Inserted lines on the
sheet below where the Vlookups are supposed to run. Now my Vlookups dont
work, when I run the macro it brings up a dialog box looking for the file
containing the lookup values. When I update the link from the edit menu it
still does that same thing. It is pulling the values off a network. I am very
confused and frustrated. Any suggestions welcome.