Hopefully someone here will be able to answer my question. I had two excel files and I wanted to merge them together to create one file. To do this, I took the smaller of the two files and copy and pasted each worksheet into the other file. I then went through and cleaned up all of the formulas on the pasted worksheets so that they did not contain references to the file I copied them from.

Now there are some problems with the code in the new file. My main problem has to do with drop down boxes. On one of the copied sheets, there are several drop down boxes. The contents of these boxes do not seem to want to stay. I was not the person to create those boxes and in the listfillrange property box it has the heading name of the column in another worksheet where the contents are located. I am not sure how excel knows exactly where to go to get the contents based on a word in the listfillrange property. My first thought is that this is where the problem is happening. Perhaps the listfillrange property is still looking to connect to the page from the workbook I pulled it from. If someone can please help me with this problem I would be very thankful.

Ryan