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