How to correctly write "Value of cell E16" while having the quotations around it.

[behnam]

part of my code which automatically sends emails out is

.Subject = "This is the Subject line"

this will basically make the subject of the emial "This is the Subject line" and the quotes are essential for the code to work. Now i want to change it in a way that the value of E16 says the subject. For example, if the value of E16 was hi, this will be equivalent to

.Subject = "hi"

Again the quotes are essential. Is there a way I can do this, thanks very much.

[Debraj Roy]

Try this..

Please Login or Register  to view this content.

[JosephP]

the quotes are only required because you are passing a string literal. use

Please Login or Register  to view this content.

specifying the sheet if required

[behnam]

Thanks both of you, my problem is solved