View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Brad is offline
external usenet poster
 
Posts: 846
Default 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