Exit Sub if sheet is hidden
 

How can I write a line in VBA to Exit Sub if a sheet named PNSheet is hidden?

Thanks

Exit Sub if sheet is hidden
 

If not Worksheets(PNSheet).Visible = True then Exit Sub

HTH
--
AP

"Alex" a écrit dans le message de
...
How can I write a line in VBA to Exit Sub if a sheet named PNSheet is
hidden?

Thanks

Exit Sub if sheet is hidden
 

If Sheets("PNSheet").Visible < xlSheetVisible Then
Exit Sub
End If

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alex" wrote in message
...
How can I write a line in VBA to Exit Sub if a sheet named PNSheet is
hidden?

Thanks