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...