It works fine for me:

i = 20
? range("A1:C"&i).Address
$A$1:$C$20


demonstated in the Immediate window. (don't use ? in a module. the
immediate window allows you to test an expression immediately - in case you
are not familiar with the immediate window in the VBE).

Regards,
Tom Ogilvy

"Gene" wrote in message
...
I have an integer variable i would like to add to a alpha
character to make a cell reference but I wasn't able to do
it, can it be done. Something like:
While something = something
i = i+1
wend
range("A1:C"&i)sort(key1 = columns("A")

doesn't work but you get the idea