Excel activities do not support R1C1 Reference Style

A small work-around that I thought of for this is the use of ASCII codes:
ex: you have the code 65 for capital A and you can use CHR(65+variable)+rownumber.ToString to enter any range you need.
Hope this helps