Sub NotEnoughInfo()
Dim EntryRwFirst As Variant
For I = 28 To WS_Count
With Worksheets(I)
Sheet_Name = .Name
Name_Start = Left(Sheet_Name, 1)
Entries = Application.WorksheetFunction.CountA(.Range("D:E"))
Filled = Application.WorksheetFunction.CountA(.Range("F:F"))
If IsNumeric(Name_Start) And Sheets(I).Visible = True And Entries - Filled = 1 Then
.Activate
For heads = 1 To 5
entry = Sheets("Analyzer").Range("C" & 30 + heads).Value
TargetSheet = Sheets("Analyzer").Range("B" & 30 + heads).Value
Set EntryRwFirst = .Columns(6).Find(What:=entry, LookAt:=xlWhole, SearchDirection:=xlNext, MatchCase:=False).Row
If Not EntryRwFirst Is Nothing Then 'search successfull, so,,,
'(irrelevant code removed)
End If
Next heads
End If
End With
Next I
End Sub
Bookmarks