Is this possible? I'm using this from Ron...


Code
-------------------
Dim strDate As String
Sheets("Quote").Copy
strDate = Format(Date, "dd-mm-yy")
ActiveWorkbook.SaveAs "Your Synthetic Shield " & ThisWorkbook.Name _
& " " & strDate & ".xls"
ActiveWorkbook.SendMail "", _
"This is the Subject line"
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
ActiveWorkbook.Close Fals
-------------------


But I want the Subject line to be values from a range, is thi
possible

--
Message posted from http://www.ExcelForum.com