referring to a column by letter, not number

in a vba code, how do I get the letter of a column for which I have the number? (i.e. from previous code I dedermined that my data is in column 15 and 15 is stored in variable mycol)