Gets the column name from a cell address.
Returns "E" from "E45", or "BR" from "BR92"
Can pass "Column_Offset" to get column name of another column related to cell address
It used to be 3 functions, got combined into one
Example:
GetColumnName("F3", -2)
will return "D"
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com
Linkedin LoginCellAddress, Optional Columns_Offset
GetColumnName("F3", -2)
will return "D"
will return "D"
Views 3,632
Downloads 1,426
CodeID
DB ID
ANmarAmdeen
711
Revisions
v5.0
Friday
July
28
2023