I edit some of that code.
address calculation has some error. ex) 78 column or something
This is a kind of 26 base calculation.
but the column alphabet in excel is slightly different from base calculation.
I didn't know that before.
For example, when I think of this as a decimal number,
1 to 9 in 1,2,3,4,5,6,7,8,9,10 there is an invisible 0 in front. 01,02,03,04~10
However, since the first column alphabet is A, B, C, D...
the base system cannot be calculated unless 'unknown empty alphabet' exists in front. like ?A, ?B, ?C, ?D...
Also, when going from Z to AA, a second piece of evidence is added that something exists before A.
If A is 0, then it must start from AA, even if A is omitted. The transition from Z to AA cannot be explained. in this case Z -> BA is correct
If A is 1, there must be an alphabet before A. but in this case. transition from Z to AA is incorrect also. Z -> A? is correct. like 9 -> 10. every transition must have that unknown empty alphabet. that way is not fit to excel column.
So I solve that by pushing and pulling the digit of 1 by counting as 0 column.
now the calculation is correct.
This problem is irrelevant if you only use columns A to Z.