I use this line in my macro

Range("b2:z2").Select
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