F
F
fandorin_official2020-02-05 12:47:34
Python
fandorin_official, 2020-02-05 12:47:34

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

2 answer(s)
A
Anton Fedoryan, 2020-02-05
@AnnTHony

x- column number More options
Split(Cells(1, x).Address(True, False), "$")(0)

R
Radjah, 2020-02-05
@Radjah

Use addressing by column and column numbers, for example.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question