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

Nevermind, I figured it out

Rya

Hey Ryan,

The ListFillRange is a named range in a workbook. I think it's a
coincidence that the named range and column heading are the same. If the
named range exists in your current workbook, you'll just need to redefine
the cells it refers to. You can do this by clicking on the range in the
Insert--Name--Define dialog box and then selecting the correct range of
cells (you can use the refedit box at the bottom of the Define dialog box).

If the named range doesn't exist in the current workbook, you'll need to
create it. If that's the case, you might want to define a different name
and then enter it in the ListFillRange.

hth,

Doug Glancy

"Ryan" wrote in message
...
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