Hello,
I have a workbook with 40+ worksheets of derived data. This data is exhaustive, i.e. only a subset of the 110+ rows in these 40+ worksheets is important. I wrote code to dynamically delete the unneeded rows in each of these worksheets, but the resulting worksheets lose all their formatting; this includes landscape orientation instead of portrait and all headers and footers. "Range" delete is used to delete the unnecessary rows-- the worksheet is not altered any other way.
Is there a way to preserve the formatting? If I copy this worksheet to another workbook will the formatting be preserved?
This is 2010 Excel.
Thanks.