Hi there,

I have a spreadsheet that by way of user input creates a list with a varying number of rows. The first first two rows contain drop down menus; second dependent on selection in first. First row draws upon a named range "Defect".

Problem is, because the number of rows vary, I can't figure out how to create the second, dependent menu. This is the code pertaining to the second drop down:

Please Login or Register  to view this content.
I believe I need If rng.Offset(, -1).Value <> "" Then to handle the initial blank value in the first column. This is however, where the code fails (among other places).

Thanks.