You have two options, as I see it. The way Autocomplete (AC) works, if
you have data in an adjoining column, AC will work the entire length of
the blank column. Therefore, you could insert a column next to your AC
column and fill will dummy data (enter 'a' and copy down). You can
then Hide the dummy column if you want.

Option two is to enter a space in your empty cells. They will still
look empty, but will allow the AC to continue to work as you go down
the column.

Does one of these work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=377046