Yes, I am sorry about that, it was not something that I did intentionally. I
was having problems with my connection. Whenever I posted the question I got
an error message that said it had not posted. My apologies. Thank you for
you're help. The code works.

"Barb Reinhardt" wrote:

I see you've asked this once before. Please only ask the question once.
Otherwise, people waste their time answering a question that's already been
answered.

"Workbook" wrote:

Is there a macro that will scan every even cell in column F for contents and
when it finds contents it will do this (ActiveCell.FormulaR1C1 = "Target") in
the even cell next to it in Column G?