Data Validation List showing blanks

[VBAotter]

I have a data validation list which worked great at first. I have it set for all of column A. Now I had to delete some rows, and now those rows show as blanks in the drop down despite having the ignore blanks box checked. How do I fix this? Why is this happening? Please and thank you! Excel 2016 Windows

 

[BrianM45]

Hi,

A screenshot please

 

[Peter_SSs]

those rows show as blanks in the drop down despite having the ignore blanks box checked

The ignore blanks box is not for ignoring blanks in the list.

Suppose with the sample sheet below, the original Data Validation was set to $F$1:$F$10 but now that range includes blank cells that you want to exclude.
For your excel version, create a list without blanks as shown in column G and put the formula shown in H1. You can then hide columns G:H if you want.
Set up your Data Validation as shown instead of $F$1:$F$10

23 03 04.xlsm
	A	B				F	G	H
1						a	a	$G$1:$G$7
2						b	b
3							d
4						d	g
5							h
6							i
7						g	j
8						h
9						i
10						j
DV List

Cell Formulas
Range	Formula
H1	H1	=ADDRESS(ROW(G1),COLUMN(G1))&":"&ADDRESS(ROW(G1)+COUNTIF(G1:G10,"?*")-1,COLUMN(G1))
G1:G10	G1	=IFERROR(INDEX(F:F,AGGREGATE(15,6,ROW(F$1:F$10)/(F$1:F$10<>""),ROWS(G$1:G1))),"")

Cells with Data Validation
Cell	Allow	Criteria
A1	List	=INDIRECT($H$1)

Then the drop-down looks like this