Copy excel table to mail message but ignore cells with zero values

**BOBMA** · 11-04-2016, 07:47 PM

Hello,
I have a table generated with different formulas that I want to copy to a mail message. After research I came up with this code:

Please Login or Register  to view this content.

My problem is that the range "X2:Z200" could have cells with zeros as result of formulas that shouldn't be copied to the message. Could anyone help find the way to prevent copying the cells wit zero values ?

Regards

**AlphaFrog** · 11-05-2016, 11:56 AM

Consider changing your formulas to not generate a zero e.g.

=IF(your formula = 0, "", your formula)

Copy excel table to mail message but ignore cells with zero values

LinkBack

Thread Tools

Rate This Thread

Display

Copy excel table to mail message but ignore cells with zero values

Re: Copy excel table to mail message but ignore cells with zero values

Thread Information

Users Browsing this Thread

Similar Threads

Copy Range and Paste only Values (ignore blank cells)

[SOLVED] Copy from Lotus note body in mail to excel cells.

If Pivot table filter isNull then how do I ignore VBA message or display "0" for pivotdata

Need to Copy Outlook 2010 Mail message to Excel 2010

Extracting mail message(outlook) table in the message body

If a Table is in the body of a mail.. want to extract the same in to the excel cells

[SOLVED] How do I get a pivot table to ignore some values

Bookmarks

Bookmarks

Posting Permissions