Add lines as follows
andFor iRow = 2 To LastRow If xlSheet.Range("G" & iRow) = "yes" Then 'add this line
End If 'add this line Next iRow
Add lines as follows
andFor iRow = 2 To LastRow If xlSheet.Range("G" & iRow) = "yes" Then 'add this line
End If 'add this line Next iRow
Graham Mayor - MS MVP (Word) 2002-2019
Visit my web site for more programming tips and ready made processes
http://www.gmayor.com