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

infazz

Board Regular
Joined
Sep 19, 2014
Messages
60
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:
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!
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,307
Office Version
  1. 2010
Platform
  1. Windows
This single line of code should do what you want...

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

Watch MrExcel Video

Forum statistics

Threads
1,108,707
Messages
5,524,424
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top