VBA Email; final part

Hi All,

I'm looking for some help in finishing off my code to send my Excel sheet as a pdf with a pre-defined email.

I have everything working but I want the subject line of my email to include the data from a specific cell. Can you let me know what I need to change / add to make this happen?

Please Login or Register  to view this content.

Thanks in advance.
Dave

.
This is one way :

Please Login or Register  to view this content.

Thanks Logit, that works but how would I have text with the cell added to the end?

Example
SUBJECT LINE - CELL F22

Wow; it was as easy as &.

Thanks.