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 to code 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 Codeder.com
Login
CellAddress, Optional Columns_Offset
GetColumnName("F3", -2)
will return "D"
will return "D"
Views 3244 Downloads 1314
VBA-Excel