Find last column in excel?

[Catalina_Rs (Catalina)]

Hi @fairymemay
I found a similar topic.

Convert integer to Excel column

Hello @mzucker use this code Convert.ToChar(Convert.ToUInt16("@"c)+4) you can also start with A but then to get D you’ll have to add 3 Convert.ToChar(Convert.ToUInt16("A"c)+3) Use what suits you the best !!! As @DanielMitchell said below the above could work for 26 letters.You could always get two letter by using an IF condition and assigning the above code twice with a + sign like this Convert.ToChar(Convert.ToUInt16("A"c)+3)+Convert.ToChar(Convert.ToUInt16("A"c)+3) So If the digits ar…

You can check if the info helps you.
I have used Convert.ToChar(Convert.ToUInt16("A"c)+3) from that link for a similar situation. You can replace 3 with the code written above for last column.