Also was wondering if maybe AutoComplete stops working after so many names
are entered into a sheet or should it keep working no matter how many cells
are filled?

"Nicola" wrote:

My AutoComplete is only working when it feels like it. Can anyone tell me
any logical reason why this would be happening?