Issue with drop down list

**hcksharp** · 04-03-2011, 11:51 AM

Hi folks,

pulling my hair out with an issue on a drop down list. For some reason it does not show part of the list after line 32 and therefor get an NA issue. Have attached the spreadsheet sample.

Thanks for your help.

Tom

**royUK** · 04-03-2011, 11:57 AM

That's simply because your named range only extends to A32, as does the Data Table. I've replaced them with Dynamic Named Ranges

**hcksharp** · 04-03-2011, 12:41 PM

Wow, thanks for the quick response. I downloaded the one you attached, but it's not any different and the issue persists. I did read up dynamic ranged, but seam to struggle with it. Appreciate your help. Tom

**royUK** · 04-03-2011, 12:50 PM

Try it again, I might not have saved all the changes to the previous attachment. I've saved & replaced the attachment

**hcksharp** · 04-03-2011, 12:57 PM

Thank you so much. Your answer and modification on the spreadsheet have more then helped me. It all "clicked" and now I better understand the functions related in it. Thank you again, Tom