Can you describe this problem again, but use Alphabet to describe Columns, and number to describe rows? You said, for example, "Rows A-C".
But rows would be 1-3.
Columns are A-C.

I can't figure out what you are trying to do without knowing which are the real columns and which are the real rows.