The offset function can do that for you. John Walk also uses the Match
function to determine column number -
http://j-walk.com/ss/excel/usertips/tip020.htm. You might be able to modify
that to handle your requirements.
"mcambrose" wrote:
I want to be able to reference cells by the row number an column number
rather than using the column letter. I am contatenating strings to make a
formula where I increment the column. I have tried r1c1 notation and this
doesn't seem to work for me. Is there a function like +cellvalue(1,1) that
will return the value in a1?