My problem is that when I use code that does a copy and then a PasteSpecial in Excel, while that code is running (ie: in a loop), I can't use the copy buffer in my system for anything else as it gets replaced with the data from the Excel copy. This happens when I use code like this:
I have no problem if I do a single statement copy in Excel VBA with code like this:
But doing it that way, I can't do a paste special which I need so that I can replace the formulas with values.
How can I get around this problem?