View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hans[_3_] hans[_3_] is offline
external usenet poster
 
Posts: 41
Default cannot copy formulas only

I use this line in my macro

Range("b2:z2").Select
Application.CutCopyMode = False
Selection.Copy
Range(doel).Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone,
SkipBlanks:=False, Transpose:=False

Some how excel copies also the values.
What am i doing wrong?
Greetings Hans