VBA Set Variable not working

[howard]

I have the folowing variable and get a run time message "Object variable with Block variable not set"

I want the sh variable for sheet "Email"


code] Dim sh As Worksheet
sh = Sheets("email") [/code]


It would be appreciated if someone could assist me in resolving this

 

[Fluff]

Try

Set sh = Sheets("email")

 

[howard]

thanks for the help. Works perfectly now

 

[Fluff]

You're welcome