Hello, I have a number of tables in my excel workbook, whose column data types I hope to format with VBA. I have setup a parameters sheet, with a table as follows TableABC in the attachment.
I hope to write VBA which will take the column headers and format them to the type specified in the next column for my tableABC. I cannot hardcode the column headers in VBA as they might change so I want to do this with a parameter table.
Kindly help with this.