My Code shown below (simply copying the formulas from the line above to a
number of newly inserted rows):-

The problem is that my users ocasionally add links to other workbooks
somewhere in the row which I am copying (for good reasons of their own). The
xlPasteformulas line then causes the 'Update Values' dialogue to pop up,
which needs to be cancelled before the macro will proceed. This routine runs
unattended at night, so this is not good ! Is there a way I can switch the
update values to default to cancel or no on the copy ? I have tried setting
application.displayalerts to False in the line above the paste, but that
doesn't help.


Rows(Insertpoint - 1).Select
Selection.Copy
Rows(Insertpoint & ":" & (Insertpoint + NumberOfRows)).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone,
SkipBlanks:= _
True, Transpose:=False, update=False