Disable Autocomplete VBA in a cell range

[excellence]

For some unknown reason, whenever I paste a letter in cell e2 that is the same as the first letter in cell e9, it Autocompletes rather than just keeping the one letter "F".
If I shut off Autocomplete it works fine.
Similarly if I move "FLAME" to another column it also works fine.

This happens in multiple columns, so I wondered if there is a way to turn off Autocomplete in the range I would like which is e2:j2 via some script, since I don't want to give up Autocomplete across all of Excel

Perhaps I clicked something inadvertently that is making Excel do this.
This behavior doesn't happen on a blank spreadsheet where putting info in e9 would not autocomplete in e2

This is on a Mac Sequoia v 16.89.1
Thanks

 

[Peter_SSs]

As far as I know you can't have AutoComplete on in one area and off in another

 

[Peter_SSs]

Just looking back on this I'm wondering if there is actually something invisible in E3:E8. Try this

1. Delete the FLAME from E2 (if still there)
2. In E2 type F and confirm that AutoComplete is still trying to enter FLAME
3. If so, select E2:E8 and hit the Delete key
4. In E2 type F and see if AutoComplete is still trying to enter FLAME

 

[excellence]

Yes, FLAME still comes up, but if E2:E8 is deleted and I enter F in E2 FLAME DOES NOT appear.

The thing that is strange is that Excel, for me at least doesn't autocomplete from a lower cell to an upper cell. So, if i had a10=hello, and then started entering in a1 hello, there would be no autocompletion or suggestion of autocompletion.
Thanks for the help

 

[Peter_SSs]

Excel, for me at least doesn't autocomplete from a lower cell to an upper cell. So, if i had a10=hello, and then started entering in a1 hello, there would be no autocompletion or suggestion of autocompletion.

That is normal AutoComplete behaviour. AutoComplete only works when there is continuous data in the column between the existing value and the cell you are now entering into.


That is why I guessed that in your example before, something (not visible) must have been in E3:E8 because AutoComplete was working (upwards) until you deleted the cells between E9 and your entry cell of E2 & then AutoComplete did not (& should not) work

FLAME still comes up, but if E2:E8 is deleted and I enter F in E2 FLAME DOES NOT appear.