Quote:
Originally Posted by gazzae
Why have you a NEXT at the top? That probably causing the error as there is no FOR. Assuming that is your whole code of course.
|
Thanks Gazzae, it is not the whole code, only a small part of it. Everything works fine up to this point, and then it has problems with the pasting. Have tried the two methods and still not working on Excel 2000, although fine on 2003.
Abs
---------- Post added at 11:15 ---------- Previous post was at 11:09 ----------
Actually starting to get somewhere now, with your shortened code gazzae!! It is now cutting columns E & F and attempting to paste, but I get cannot change part of a merged cell. Any ideas?
Abs