For Bold,Font, Font Size and Syle Formatting
chWorkSheet:Range("A1:BB7"):Font:Bold = TRUE.
chWorkSheet:Range("A1:BB65536"):Font:Name = "Times New Roman".
chWorkSheet:Range("A8:BB65536"):Font:Size = 9.
chWorkSheet:Range("C8:BB65536"):Style = "Comma".
chWorkSheet:Range("C6:AX6"):NumberFormat =...