row values a -> z aa ->zz

I can use a formula like this, with I1 = A =CHAR(CODE(I1) + 1) And it will produce A to Z. But is there some way to have cell values automatically generate down like column letters? a -> z then a...