I have a a small spreadsheet that I copy into an email and send out. I use a macro to accomplish this, however some of the cells unformat when it's pasted into the email, so it makes it look funky. Within this spreadsheet I email, I have a range of cells that are aligned "Center Across Selection" as headers rather than merging them (cause we all know the troubles we have with merged cells). When the spreadsheet is copied into an email, some of the headers loose their center formatting and now I see 3 cells instead of one long one, with the title scrunched up in the first cell, or sometimes it adjusts the size of the cell to accommodate the header in one cell.
Does anyone know what is causing these cells to loose their center formatting and how to correct this?
Does anyone know what is causing these cells to loose their center formatting and how to correct this?
