Tools|Options - general tab and uncheck R1C1
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
And for XL2007, click Office Button, Excel Options Button, select Formulas
from the left hand listing and uncheck "R1C1 reference style" in the
"Working with formulas" section in the right hand listing.