GetColumnName, ColumnName_XOffset

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"

CodeFunctionName What is this?

Public

Tested

Original Work

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 Bold.codes

Linkedin Login

CellAddress, Optional Columns_Offset

GetColumnName("F3", -2)
will return "D"

Views 3,632

Downloads 1,426

CodeID
DB ID