O
ordnance1
How can I make this code work on my worksheet named February, when it is not
the active worksheet?
Sub BlankWeeks()
'
' Macro2 Macro
'
'
If Range("C184").Value = "" Then
Rows("184:228").Hidden = True
End If
If Range("C184").Value <> "" Then
Rows("184:228").Hidden = False
End If
If Range("C229").Value = "" Then
Rows("229:273").Hidden = True
End If
If Range("C229").Value <> "" Then
Rows("229:273").Hidden = False
End If
End Sub
the active worksheet?
Sub BlankWeeks()
'
' Macro2 Macro
'
'
If Range("C184").Value = "" Then
Rows("184:228").Hidden = True
End If
If Range("C184").Value <> "" Then
Rows("184:228").Hidden = False
End If
If Range("C229").Value = "" Then
Rows("229:273").Hidden = True
End If
If Range("C229").Value <> "" Then
Rows("229:273").Hidden = False
End If
End Sub