I have an XL macro that copies selected rows/cols into the clipboard, then the user pastes the clipboard data into a Word document. The paste into Word is hanging up with an hourglass. It used to take about a minute to copy. In one week it jumped up to 9 minutes.
The copy process is within the macro, the paste process is a manual process. At first I thought maybe the data was getting too big for the clipboard, but last week it was 36,094 characters, this week it's 36,496 characters - an additional 402 characters.
Any ideas as to why this could suddenly be taking so long to paste??
TIA...MJ
OS = XP, Office = XP