[VBA] Converting a column of numbers to a a column of letters.

[infazz]

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:

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!

 

[Rick Rothstein]

This single line of code should do what you want...

Range("D3").Resize(36).Value = Evaluate("IF(D3:D38="""","""",CHAR(64+D3:D38))")

 

[infazz]

That did exactly what I needed! Thanks!

 

[infazz]

Everything is working well! thanks!