cannot copy formulas

[hans]

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

 

[hans]

I use this line in my macroRange("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

 

[BrianB]

'-------------------------------------
Range("b2:z2").Select
Range(doel).Select
'--------------------------------------
You immediately change the selection, so the first line is not needed.
'-
You say that values are pasted.
1. You will need to check your formulas are correct, because if the
refer to the same cells then they will of course show the same values.

2. Or, perhaps, you have Calculation set to Manual when the cells woul
not change until a re-calculation occurs.


Hope this helps