I have ranges on a sheet
B10:b19
B21:B30
B32:B39
B41:B48
B50:B57
B59:B66
If those Ranges are totally blank then I want it exit and not call module
then if one of the ranges has a cell populated then it calls the module.
Code i Have that calls the module now is
what would I add to make it do what I would like.![]()
Private Sub Worksheet_Activate() Call PopulatesJobTicket.NewDateRange End Sub
Bookmarks