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
|