Switch to R1C1 Notation. It makes a lot of Excel magic easier to understand.