Hi everyone.........
I've created a contiguous list of text data in a column from row 1 to row 3200. Rows 10 to 2999 have been filled with 'x' to ensure there are no spaces. I want AUTOCOMPLETE to be active when I overwrite any of the 'x' cells with new text. Clearly, this means that I will be entering data into the middle of a data range.
I've proven that this works using a smaller range, but it doesn't work with the 3200 rows I need. This suggests there might be a maximum limit to the number of rows that AUTOCOMPLETE refers to.
Can you pls shed some light on this?
Regards......... Keith T
I've created a contiguous list of text data in a column from row 1 to row 3200. Rows 10 to 2999 have been filled with 'x' to ensure there are no spaces. I want AUTOCOMPLETE to be active when I overwrite any of the 'x' cells with new text. Clearly, this means that I will be entering data into the middle of a data range.
I've proven that this works using a smaller range, but it doesn't work with the 3200 rows I need. This suggests there might be a maximum limit to the number of rows that AUTOCOMPLETE refers to.
Can you pls shed some light on this?
Regards......... Keith T