Cell reference in code

J

J.W. Aldridge

I use this automated email code from one of the experts however, I'd
like to change point the subject field to a cell reference - the value
(always a date) in cell G1.



..Subject = ""
 
P

Per Jessen

Hi

..Subject = Range("G1").Text

Or

..Subject = Sheets("Sheet1").Range("G1").Text

The sheet reference is only needed if sheet1 isn't the active sheet.
 
Top