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.
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
' 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
ANmarAmdeen
602
Revisions
v1.0
Friday
November
26
2021