Get the column name associated with the column index (if column metaData is being used)
The column index
Add square brackets to the column name (square brackets allow spaces and other non-allowed characters to be used in database column names)
Debug.Print lst.ColName(4) -> CategoryName Debug.Print lst.ColName(4, True) -> [CategoryName] lst.ColName(4) = "NewColName"