PDA

View Full Version : Copy/Paste Data turns black



lokewolf
10-15-2008, 06:56 AM
I have an issue where I'm copy/pasting data from one workbook to another and for some reason the cells that are pasted into turn font and interior color to black. So then you have to go change the colors back to clear and black. Sometimes I'm working in two different versions of excel, one is my normal everyday excel and the other is a version of excel built/used by a application we use at work...it spits out reports in excel. Some times the data is fine, sometimes its not. Same goes for when I open a excel attachment from an email... doesn't happen all the time, but its a PITA when it does. Any ideas?

CreganTur
10-15-2008, 07:47 AM
PITA
Mmmmm... flatbread sandwiches:love:


have an issue where I'm copy/pasting data from one workbook to another
Are you doing the C&P by hand or is it accomplished using VBA? If it's VBA then please provide code.

lokewolf
10-15-2008, 07:49 AM
Manual Copy/paste. thx