Thanks guys for the suggestions! They both solved my problem...
I have another question. In my code, if c.value = CurrentWk, i want it to select c and select 15 rows going down. how do i do this?
![]()
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