The function ColumnIndex returns the index of the column of which the header matches the parameter Head. If the parameter PartialMatch is TRUE a
match occurs if the Head is a substring of the
column header, otherwise the Head
parameter has to be equal to the column header. The
match is not case sensitive. If no column can be found, a value of -1 is returned (valid range: -1, 1..NrOfColumns ).
Hint: |
If there are several columns having the same header, the index of the last matching column (highest column number) is returned. |
|