E-mail last row of data in workbook

[beenbee]

Hi Everyone,

I found a nice script that using outlook, e-mails a specified range of cells. However I would like the script to e-mail the last filled row of cells. I have had a go at amending it myself my keep butting my head up against it one way or another. At the moment I get an compile error, type mismatch. I just can't work out how to get the two pieces of script to work together.
Any help would be great!!

Please Login or Register  to view this content.

[nathansav]

set source = worksheets(strSheet).usedrange.row(worksheets(strSheet).usedrange.rows.count)

[beenbee]

Thank you very much for your reply. I don't want to be a noob but I can't get your suggestion to work for me. It keeps bringing up the error message written into the code. I have tried messing around with it, to no avail. I have attached my wb so anyone can have a closer look.
Thank you in advance.

[beenbee]

This was solved in another thread I posted for the same issue.
Here is the link to that post; http://www.excelforum.com/excel-prog...ml#post3528935

And the code;

Please Login or Register  to view this content.