Macro is not working
I'm getting this error Run Time error '91' Object variable or with block
variable not set.
When I hover the cursor over
shtFixD.CodeName - I get
shtFixD.CodeName = 'shtFixD' - which is correct
When I hover the cursor over
UpdateSht - I get
UpdateSht = nothing - which is the problem
Sub testrange()
Dim UpdateSht As Worksheet
Select Case shtInput.Range("RiskT").Value
Case Is = "Fixed"
UpdateSht = shtFixD.CodeName
Case Else
UpdateSht = shtVarD.CodeName
End Select
UpdateSht.Range("C16").EntireRow.Hidden = True
End Sub
|