Unable to Set A Variable Worksheet

[Ark68]

I'm having an issue:

Dim wsho_rpt as worksheet
Set wsho_rpt = Worksheets(wshvar.Range("J52").Value)
            With wsho_rpt
            ....

I am failing as assigning wsho_rpt as a worksheet. When I debug this code, wshvar.range("J52").value returns "HPL", but wsho_rpt returns "Nothing". As a result, my code isn't working.

What I am trying to do is set wsh_rpt = worksheets("HPL")

 

[RoryA]

That code looks OK to me, although I note that the word Worksheet is not capitalised - do you have another variable by that name?
Also, do you have an error handler in place that might be hiding errors?