Sorry NoSparks, what I am eluding to is the 1st sample sheet with the formulas. It seems to error when it detects a space or a box without a semicolon. (I am changing the selection area to fit what I need it for.) I am trying to make it "look" like a warehouse with title boxes that say A1C4 (Aisle 1 Column 4).