I have a worksheet which when I have a duplicate entry, I cut and
paste the needed information to the original. However, when I do
this, the formula of the orginal then changes and has #ref in it.
How do I prevent this?
Also, is there a way that I could use a macro to then go to the item
I just copied and paste and delete that row.

Any help would be great.

Di you try Copy/Paste Values?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion