AutoComplete in a large worksheet

[Guest]

I have over 1,000 hymn tune names in a worksheet, and when I'm adding new
entries to the bottom of the continous column of names, AutoComplete
sometimes works, sometimes doesn't. It always works when I'm entering
something that duplicates another entry I've made during that particular
session, but not always when I'm duplicating data from a previous session.
There are no breaks in my column, and AutoComplete is enabled. Is the size
of the sheet the problem?

Thanks.

 

[Frank Kabel]

Hi
it won't work if there're blank rows in between

 

[Guest]

Thanks for your reply. There are no blank rows in between. Any other
possibilities?

Rotwang

 

[Gord Dibben]

Frank

Your prolific posting is legendary, but how often do you read the original?

Gord Dibben Excel MVP

 

[Frank Kabel]

Hi Gord
my posting should have read:
Are you sure where are no ....

 

[Gord Dibben]

Apolgies for the crack Frank.

Bad day all-round.

Lost my match on 18th hole when I went OB.

Gord

 

[Frank Kabel]

Hi Gord
no apologies needed
Especially in this case after loosing a match on the 18th <vbg>

Frank