Hey tstom

Great workaround! I think this is just what I need. I'll test it out monday at my job and let everyone know.

I have a question, though. When you use PasteSpecial (3), what xlPasteType is that? I looked up the enumerations but didn't see 3 or any addition of the xlPasteType values that added up to 3. The only thing that was 3 was xlPasteSpecialOperationSubtract for the xlPasteSpecialOperation...is this what that means? Doesn't seem to be, but I'm not sure.


Anyway thanks again for the workaround, I really appreciate it. I do believe I will be needing to keep the formats so this will be excellent. Just curious, what better options do we have if I just want to paste values?