Yes I have although at times, it looses the formating of the cells which it is going too. It also leaves the values at the cells I moving.
Quote:
Originally Posted by GS[_2_]
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 |