Data validation drop downs don't recognize dynamic named range

G

GlenC

I've set up a worksheet where row 2 contains column titles and data
validation.
Below this is are the data entry cells with validation lists based on column
title.
The validation lists are named ranges on another sheet called Tables. I get
proper drop downs.

When I change a name reference to
"=OFFSET(Tables!$B$2,0,0,COUNTA(Tables!$B:$B)-1,1)" I no longer get the drop
down. When I try to GoTo the named range it doesn't show on the GoTo list.
Formulas like "=CountA(Media)" work correctly.

Any help would be appreciated.

Glen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing named Validation list to Dynamic list. 1
Data Validation List 1
drop box/data validation help 0
Multiple Dynamic Named Ranges across Columns 3
Data validation list using filtered range 3
i to = column in Formula 19
Data validation issue with multiple columns 1
Data Validation with dynamic ranges 2

Top