ExcelBanter - Problem With Drop Down Box

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Problem With Drop Down Box (https://www.excelbanter.com/excel-discussion-misc-queries/177996-problem-drop-down-box.html)

k1ngr

Problem With Drop Down Box

In Excel 2007, using the Drop Down box to go to a named range causes Excel to
abort and send an error message to Microsoft. If I just type in the name of
the range and hit ENTER, it works fine.

I have uninstalled/reinstalled from the original CD and installed Office
2007 SP-1, but the problem persists.

Any suggestions on how to solve this problem?

Dick King

All times are GMT +1. The time now is 08:02 PM.