From the other answers and since they all seem to lead in about
the same direction, it might be possible that you are trying to do something
like the first macro, InsertRowsAndFillFormulas in
http://www.mvps.org/dmcritchie/excel/insrtrows.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"RAD" wrote in message ...
In a script I want to copy only formulas, not values.

Currently I use this code for the 'paste' operation, but this also copy raw
values, what I do not want.

Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

Thanks