VBA, Excel Email Subject with last row, column B only

[Bluesguy07]

Hello friends,

I'm trying figure out how to place in the subject, of an email generated through Excel, just what is in column B, last row. I'm having issues with that. Here is my code below, well not all of it... but I believe you should be able to give me what I need. The subject will be "Shipping Request From" and then Last Row, Column B

If you do indeed need more from me, let me know.


With CreateObject("Outlook.Application").CreateItem(0)
.To = ThisWorkbook.Sheets("Sheet3").Range("A2").Value
.Subject = "Shipping Request From"
.HTMLBody = RangetoHTML(rngAttach)
'.Send
.Display



Thanks in advance

 

[KKaren]

Hi,

I assume you mean value of the last row in column B in Sheet3? In such case, this should work:

.Subject = "Shipping Request From" & ThisWorkbook.Sheets("Sheet3").Range("B" & Rows.Count).End(xlUp).Value

 

[Bluesguy07]

Thanks! That's exactly what I was looking for.