Radical color chages on importing a worksheet (Excel 2010)?

D

djo77399

I have a complex requirement in Excel 2010 that requires me to impor
sheets from multiple workbooks and collate them into a single workboo
for distribution. These other files have background colors in the row
alternating beige and no-color. There are group headers that ar
backgrounded in gray. The beige rows import as neon green (you can'
make this stuff up!) and the gray rows import as neon red. In othe
imported sheets, the beige background imports as black and the tex
(foreground) as red.

I have no idea what's going on, but this needs to NOT HAPPEN. I am usin
a VBA routine to do the work, but the same thing happened when I did i
with manual cut-and-paste.

If someone can help me out on this please! I have to get this thing int
production soon. I'm an experienced ABV/Access developer, but have ver
little Excel experience.

Thanks a million!

Dennis


PS: The Crystal reports Export function exports the report in "Exce
97-2003" format only. I need all formatting and colors to remai
identical to the source sheet when I bring the external sheets in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Color rows based on a cell value 2
Changing the color of a cell in excel based on due date 2
Excel Worksheet 0
Excel 2007 cell color changes when copying to other excell 2007 document using clipboard ? 4
Change cell background color based on content that results from li 4
Split a worksheet into multiple worksheets of the same Excel file 1
conditionally formatting 3
Is it possible to modify the fill patterns in Excel? 0

Top