E-mail last row of data in workbook

Hi Everyone, I posted this before the holidays and had a suggestion back however I'm having some trouble getting things to work together.
[URL="http://www.excelforum.com/excel-programming-vba-macros/976482-e-mail-last-row-of-data-in-workbook.html#post3519561[/URL]
What I am trying to achieve is, to be able to e-mail (using outlook) the last new line of data from sheet1 in my workbook. The error message I am getting is "The source is out of range" I have tried setting the source range in a couple of ways but keep getting error messages. Any help will be very appreciated.

Please Login or Register  to view this content.

Thank you very much for the reply. The "wb" variable was defined in my list of variables.

Please Login or Register  to view this content.

I've given it a go in the place you suggested, and added "Active" but I don't believe moving the variable position makes any difference.
Thank you anyways.

Thank you very much for the last post. I like the approach, the thing, is there a way for the new sheet created to be automatically attached to the e-mail or am I supposed to add it each time. FYI I'm using office 2003. I have gone through the code in break mode and it doesn't execute the last section of the code, instead jumps back up to .diplay (before the function)

This is where it breaks;

Please Login or Register  to view this content.

Sorry I don't know enough about what its doing to try and remedy this myself.
Thank you again for the help.

Thank you so much for all your help on this issue. The solution works great. Thank you and Happy New Year!