cannot copy formulas
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
Somehow excel copies also the values.
Whay am i doing wrong?
Greetings Hans
|