excel - Function to convert column number to letter? -


does have excel vba function can return column letter(s) number?

for example, entering 100 should return cv.

something return letter column 100

function col_letter(lngcol long) string dim varr varr = split(cells(1, lngcol).address(true, false), "$") col_letter = varr(0) end function 

test code

sub test() msgbox col_letter(100) end sub 

Comments

Popular posts from this blog

qt - QML MouseArea onWheel event not working properly when inside QML Scrollview -

java - is not an enclosing class / new Intent Cannot Resolve Constructor -

python - Error importing VideoFileClip from moviepy : AttributeError: 'PermissionError' object has no attribute 'message' -