Validation list not showing in cell

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I have Validation set in a column. It's set to show me a drop-down list.
When I click in a blank cell, I get the drop-down arrow, but not the list.
If I right-click in the cell, I get Pick From List, which has everything on
the Validation list.

The Validation list is made by selecting the column, pulling out all unique
values, then pasting them into another range and setting this range as my
Validation list. I can go to the previously-filled in cells, and get the
whole drop-down list. But the blank cells do not have the list. (I have
ensured the List Range is not affected by any filters, hiding, etc.)

Is there something I forgot to set?

Ed
 
Found the problem: When I set the Validation Range, I did not use absolute
reference. So my range AD10501:AD10572 was constantly shifting; 4,000 rows
down my spreadsheet, I'm at AD14501:AD14572, which has nothing in it! The
macro now sets the ranges up as $AD$XXstart:$AD$XXend.

Ed
 

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

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data Validation List (Drop Down) Not Showing 2
Data validation list using filtered range 3
Size of drop down in validation list 2
Filtered drop down list 2
Validation From List Not Working 4
Data Validation - List of unique values 2
data - validation - list question 2

Back
Top