Help with VBA Code to rename column title

Hello All,

I have a monthly csv file that I import data including column titles into an excel workbook and that’s working fine, my issue is I need to rename one of the column titles on the excel workbook from “TIBEN” to “TICKET #”, which is located in Row 1, Column F.

And I haven’t been able to find the right vba code to rename the column, also I’m not sure where I need to place the rename vba code, at the beginning of the import data vba code or at end of it? Any assistance will be greatly appreciated!!!

Cheers,

GD

The code did not work, my apologies I forgot to mention I have the attached Class Module for columns, if that helps? Thank you so much…

Cheers,

GD