Hi All
I have the code to copy and paste multiple columns from one sheet to another. I want to tweak the code to format the heading cells (A1:D1) of the destination Sheet ( Final) as follows:
1. AutoFit Column Width
2.Cell Colour= Moderate effect- Blue, Accent 1
3. Font size = 12
4.Font Colour= White
5.Bold font
Any ideas on how to do this is much appreciated. Many thanks
Please Login or Register to view this content.
Bookmarks