Select the range. Copy . Keeping the selection. right
click..PasteSpecial,,Values.. OK
--
If this post helps click Yes
---------------
Jacob Skaria


"backmara" wrote:

How I use functios whit "paste special?
Meaning: I have data A1 and 1 use some function A2, after that I have to
delete colum A1. So A2 get #REF!, how I have to do this?