email message body

[rjplante]

I have some html code in cell Z1. I used Dim EM_Body As String to define my variable. I then use the line below to define my variable. When I run the code I get a Compile error - Object required. What do I need to do to get this to run correctly?

Set EM_Body = Sheets("Transfer page for Pending Exp.").Range("Z1").Value

Thanks,

Robert

 

[lrobbo314]

You don't need the word 'Set' in your line of code.

 

[rjplante]

Now I get a Run time error 9 - subscript out of range.

 

[lrobbo314]

Are you sure that you have your sheet name spelled correctly in your code?

 

[rjplante]

Yes I have copied the sheet name from another line on the code which works just fine. I did double check to make sure that I wasn't missing a quote or some other small thing that would cause the code to fail. Nothing seems to be missing.

 

[lrobbo314]

Maybe

EM_Body = Sheets("Transfer page for Pending Exp.").Range("Z1").Text

 

[rjplante]

Same error with .text as well.