R1C1 vs A1: Add to column "A + 1"?

Hi all,

Just wondering. Is it possible to "add" to a letter, in the way you would with R1C1 style formulas?

I've always worked with LetterNumber style formulas, but I'm trying to add another iteration to a formula and while I can add to the row, I can't increase the column. I mean, you can't exactly say "Q+1" ... or can you?

Edit: I should mention, the formula I'm currently working with is...

.FormulaArray = "=SUM((Data!P3:P" & lastrow & "=A2)*(Data!Q3:Q" & lastrow & ">0))"

...I'm trying to make it so that on the next loop through (I'm copying the formula into multiple columns) Q3:QLastRow will be R3:RLastRow, and so on until the Do...Until loop closes. (The loop uses "loopcount" as an interation counter, so effectively it would be Q + "loopcount" iterations)

Thanks in advance,
Bob