View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Copying the colors of one Matrix to Another?!

Hi Mike,

Maybe related to those CF's. For testing clear them all and work from there.
If that doesn't work post again and I'll drop you a line.

Regards,
Peter T

"Mike" wrote in message
ups.com...
Trevor/Peter,

Well, I have a problem here. When I applied Trevor idea on a new sheet,
it did work well and thought the problem is resolved!

But, when I created a Macro to copy colors of one matrix into another,
the colors are no longer same as in the original matrix!? For example,
the RED cell becomes light green in the nex matrix!

Let me know if I can email you the file itself. It is small one anyhow?

My email is


Mike