I'm trying to fix my macro so the table portion of my email body only includes Visible cells with Values but as it is currently written, it ignores the xlCellTypeConstants enumeration. Is there a way to include both xlCellTypeVisible and xlCellTypeConstants? I've attached my current spreadsheet and the code can be run by clicking the Command Button at the top.
Bookmarks