GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this one returns the index of that column, having option to pass it offset.
Stupid maybe, I know, but I needed that here to fill in some void in my library.

CodeFunctionName
What is this?

Public

Tested

Original Work
Function GetColumnIndex(CellAddress, Optional Columns_Offset = 0)
    ' Returns index of column for a certain cell, with option to offset of it
    GetColumnIndex = Range(CellAddress).Offset(, Columns_Offset).Column
End Function

CellAddress, Optional Columns_Offset = 0

Views 73

Downloads 39

CodeID
DB ID