cannot copy formulas
 

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

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

cannot copy formulas
 

'-------------------------------------
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

--
Message posted from http://www.ExcelForum.com