Answer the question
In order to leave comments, you need to log in
How can I get the letter of a column from Excel according to a number?
Can someone tell me if there is already some ready-made solution.
For example, I have a number. And according to this number I need to get the column letter from EXCEL.
Well, for example, index 1 is A , but index 27 is AA . Well, in that spirit.
Answer the question
In order to leave comments, you need to log in
x
- column number More options
Split(Cells(1, x).Address(True, False), "$")(0)
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question