Queries automatically create & maintain range names.

if you base your dropdown source on that NAME rather than the address
things should go as planned.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


DevalilaJohn wrote in


I have a worksheet with a drop down of active projects in one of its
columns. The data on what projects are active comes from a SQL
server database. To start the process I defined a range that
includes all the imported project data, created the drop down and
copied it to the appropriate number of rows in the Projects column.

I have the query dropping the data to an area outside of the normal
viewing area. Over time, the project mix will change, so I need to
update the dropdowns(s). I have no problem refreshing the data from
the query, but seem unable to get the range to resize in the
dropdowns following the example in the online documentation. I
intentionally used a named range assuming that would eliminate the
need to go row by row to update the dropdowns.

This leads me to two questions:
1. Are the data in the dropdowns static once populated, or should
resizing the range effect the dropdowns?
2. Am I going about this whole thing correctly?

Thanks in advance for any assistance or insights.

John