Replicate Report Borders and other Formatting in VBA Module

[ExcelSeriousFun]

I have "inherited" several reports for Excel 2010 where the data is generated via VBA but the formatting of the reports, including borders, merged cells, font styles, etc were manually added to the sheets. I wish to replicate these formatted characteristics into the VBA modules that create the data. In that way if I have 20 reports that I wish to create, I could use only a single sheet rather than 20. I'm doing this to simplify the output as well as to reduce the size of my workbook.

I suppose that ideally I'd like to have a sort of VBA generator to be able to insert the report formatting into a VBA module.

Thank you for considering this.

 

[taurean]

Welcome to MrExcel.

You can use macro recorder to generate the preliminary code for formatting. Once this is done then you will have to incorporate in the inherited code or call it from there.

If formatting pattern is the same then it will be easier to maintain the code.

 

[ExcelSeriousFun]

Thank you for your reply. I am hoping to NOT replicate the borders and other cell formatting. I'm looking for some sort of VBA generator that, given a range of cells on an existing report, will generate VBA formatting code identical to the existing report. Then, I would paste the VBA code into the report-generating module.

Thank you.