I assume that that link works, but a came up with a VBA subroutine that when called from the worksheet's Change event works for me so I'm going to mark this thread as resolved.