As is often the case:

"I hate that my code does what I TELL IT TO DO instead of WHAT I WANT IT TO DO"

how is excel supposed to know what you "mean" if you don't tell it..