Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
I'm having an issue:
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")
Code:
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")