VBA format as table with custom colours and alignment

Hi all,

A bit of a VBA challenge here. I'm trying to find a code that will;

1. change cell colour of first row of selected cells to hex code (123,0,0) [row header]
2. change text colour of first row of selected cells to white and bold [row header]
3. add All Borders to selected cells
4. add Thick Outside boarder to selected cells
5. add Thick Outside boarder to first row of selected cells
6. Center Align and Middle Align selected cells
7. add filter to selected cells

Any help would be very gratefully received!

Have you considered creating a table theme and applying that?

Ah, context.

You may consider then writing the code so that it saves the table format as a table style. This way they can use that style of table without needing code in other files and recipients of said files can also use the table style within those files without running a macro. You could further extend it in the future, should you need, to have the code generate multiple table styles instead of a single on.

Perhaps this

Please Login or Register  to view this content.