ExcelBanter - AutoComplete not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - AutoComplete not working (https://www.excelbanter.com/excel-discussion-misc-queries/73252-autocomplete-not-working.html)

Phippsy

AutoComplete not working

I have a spreadsheet with 4660 rows and AutoComplete does not pick up
anything before row 4007.

Why is this?

Thanks

All times are GMT +1. The time now is 01:41 AM.