Try this
![]()
Public Sub NT_comment() Dim c_ell As Range, Date_Ref As Date, S_heet As Worksheet, c_ell2 As Range For Each S_heet In ActiveWorkbook.Sheets If Left(S_heet.Name, 3) = "ACD" Then With S_heet For Each c_ell In .Range("D2:D" & .Range("D" & .Rows.Count).End(xlUp).Row) If c_ell = "C to BBNT" Or c_ell = "Will C SD" Then c_ell.Offset(0, 1) = "OK" Else If c_ell <> "" Then c_ell.Offset(0, 1) = "Not OK" End If Next c_ell End With End If Next S_heet End Sub
Bookmarks