hi, i have a problem...
i have a list box and 5 dynamic named ranges. i also have a series of 5 option buttons that control which of the 5 named ranges is the one i want.
what i want to do is have the Input Range for the list box dynamically update with the named range chosen via the option buttone. unfortunately, it seems the the contents of the Input Range must actually be a defined range and cannot be a formula (indirect, address), and also cannot be a reference to a cell which contains the named range as its value.
any thoughts on how to accomplish this?
thanks
Bookmarks