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