Where does the error occur? You know macros do not adjust to changes. It's
probably referencing to an invalid cell or worksheet. Copy and paste where
you got the error and we'll take a look at it.

"DP7" wrote:

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.