See answer in your FIRST post

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Workbook" wrote in message
...
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?