You have one response to your earlier post.

tomwashere2 wrote:

I would like to truncate the data between the subtotals when sending an email
with the subtotal data.

Excel will summarize the subtotals in one page however when I send an email
with this data highlighted, it also includes all the data in between.

Please let me know if there is a way to do this using VBA. What I have done
in the past is to copy the data and paste it to Notepad and then copy the
subtotals off the notepad and send the date via email.

--

Dave Peterson