The issue arises because the cell Value doesn't actually change until you navigate to another cell. Read the last two sentences of the quote in my last post again.