I am doing some transcription work and I'm wanting to disable AutoComplete cell values for columns F & G. I have Excel 2007. I found the following code and changed "A" to F but I can't figure out how to disable column G as well. Surely there's a way to do this. I appreciate any help anyone can give me. Thanks in advance.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Select Case Target.Column
' Disable for column A - change to suit
Case 1
Application.EnableAutoComplete = False
Case Else
Application.EnableAutoComplete = True
End Select
End Sub
Bookmarks