So I have some vba code that copies and pastes non-adjacent cells from one sheet to another and it stoped working when Excel was upgraded from 2000 to 2003. I searched the Internet for a solution and found a few people with the same problem but nobody seemed to have a definite solution.
The code would halt at: "ActiveSheet.Paste".
The solution was to use: PasteSpecial xlPasteValues, SkipBlanks.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment