I have a Calender worksheet, I need the macro to search row 1 (days
Mon-Fri), find only the Fridays, then search down the column until it finds
a name (John), then put "OK" into the corresponding cell? I wrote one where
searches each row & column by using "next". However, its not changing the
corresponding cell value.