Just as an after thought, is there a way of making the input in A2 case insensitive as currently you are required to type A, B etc so it would be nice to get it to work with a, b etc
Hi,

Just add following one line on the top the code makes case insensitive

Option Compare Text