Simplify
to![]()
Do For Each c In Range("A5:A" & r) If c.Value = CurrentWk Then 'Select range going down 15 rows c.Select End If Next c Loop Until c.Value = CurrentWk
![]()
For Each c In Range("A5:A" & r) If c.Value = CurrentWk Then 'Select range going down 15 rows c.Select Exit For End If Next c
Bookmarks