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 Mydevlib.com

Linkedin Login

Parameters

CellAddress, Optional Columns_Offset

Examples

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

Permanenet link

Statistics

Views 3,632

Downloads 1,426

IDs

CodeID
DB ID