Need help inserting formula with macro
not sure if this is what you want or not
With Sheets("MergeList")
.Range("A2").Formula =
"=IF(NotificationFormat!F2<"""",NotificationForma t!F2,"""")"
End With
post back which column you determine where the last row is.
--
Gary
"Judy Ward" wrote in message
...
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
|