This is my first post on Ozgrid, and I'm still pretty new at creating macros using VBA. Any help would be appreciated.

I have contact info (First Name, Last Name, Address 1, City, etc) that gets exported out as a CSV file regularly. I am trying to make a macro to clean it up so that it is easily viewable.

The column headings are consistent, but their order can change based on who has given me the file (ie today the order Columns A,B,C,D is: 'First Name', 'Last Name', 'Company Name', 'Address 1', etc, but tomorrow it might be 'Last Name', 'First Name', 'Address 1', 'Company Name'). Each of these columns need to have something different done to them (Ex: Make 'Company Name' Bold), but what is the best way to do this?

Is there any way to "attach"...