counting in letters

I am basically looking for a method to fill in information through VBA in excel into a 2-D grid. Ideally I would like this to work but it does not.

For row = 1 to 10
     For column = A to D
     Range(column, row) = whatever
     next column
next row

Is there a way to do something like this? Basically looking for a way to count through the alphabet.