I would like to turn off autocomplete for one cell only.

I understand that I can do this by having a blank line above and below the
cell and a blank column to the right and left of the cell. Is there any
another way??

This is for cell B9, adjust to suite:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("B9"), Target) Is Nothing Then
Application.EnableAutoComplete = True
Else
Application.EnableAutoComplete = False
End If
End Sub

This is worksheet event code and goes in the worksheet code area, not a
standard module.
--
Gary''s Student - gsnu200764


"Brad" wrote:


I would like to turn off autocomplete for one cell only.

I understand that I can do this by having a blank line above and below the
cell and a blank column to the right and left of the cell. Is there any
another way??

Thank you!

That was easy!

"Gary''s Student" wrote:

This is for cell B9, adjust to suite:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("B9"), Target) Is Nothing Then
Application.EnableAutoComplete = True
Else
Application.EnableAutoComplete = False
End If
End Sub

This is worksheet event code and goes in the worksheet code area, not a
standard module.
--
Gary''s Student - gsnu200764


"Brad" wrote:


I would like to turn off autocomplete for one cell only.

I understand that I can do this by having a blank line above and below the
cell and a blank column to the right and left of the cell. Is there any
another way??