Hello!
I'm working on a project and I need to copy a column of numbers in a worksheet and paste it as a column of letters in another worksheet.
I only need to convert one through ten to letter "A" through "J".
All I have is:
Thanks!
I'm working on a project and I need to copy a column of numbers in a worksheet and paste it as a column of letters in another worksheet.
I only need to convert one through ten to letter "A" through "J".
All I have is:
HTML:
Sheets(convsheet).Range("D3:D38 ").Copy 'For Range("D1:D38") 'Numbers need to be converted to letters (A,B,C,D,E,F)Sheets("RawData").Range("D405").PasteSpecial xlPasteValues
Thanks!