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.
Please Login or Register to view this content.
Last edited by Leith Ross; 09-27-2012 at 11:25 PM. Reason: Added Code Tags
Hello Leslie88,
Columns "F" an "G" are column numbers 6 and 7 respectively. Here is the updated macro code...
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you so much! You made my job a lot easier. The mistake I was making was that I didn't change the case number because I thought the case number was the act itself. I didn't know that the case was actually referring to the column numbers.
Thanks again for all your help. Have a great week!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks