I have a workbook with several worksheets. The "MergeList" sheet relies on
information from the "NotificationFormat" sheet. Here is the formula used in
cell A2 of "MergeList":
=IF(NotificationFormat!F2<"",NotificationFormat!F 2,""

This formula is copied and pasted to the rest of the cells in the column so
that the row number increments.

A copy of this workbook is used over and over again and somehow this formula
gets messed up or deleted completely. I would like to have a "reset" macro
that inserts this formula in cell A2 and copies and pastes it to the rest of
the cells in the column.

I can't even get the part the inserts the formula to work:
Sheets("MergeList").Select
With ActiveSheet
.Range("A2").FormulaR1C1 =
"=IF(NotificationFormat!F2<'',NotificationFormat! F2,'')"
End With

I get "Run-time error '1004': Application-defined or object-defined error"

I would appreciate any help you can give me.

Thank you,
Judy