View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RAD RAD is offline
external usenet poster
 
Posts: 13
Default How can I paste formulas only an not values

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