VBA Novice having problems with colours.

[Simoninparis]

Hi,



Can anyone help?

I'm a novice to VBA but, after many years resisting, I have finally bitten the bullet.

I'm trying to automate some student records I have to administer.

Some of my fields (cells) contain three colours - black for the original criterion, red if work is needed, green if the skill is already acquired.

I have transferred all my data using a macro from 120 files into one unreadable (but well-mapped) spreadsheet.

When I try to call the data using VBA into a spreadsheet resembling the old form, I get the data but it's all in black.

Any advice would be appreciated.
Thanks....

[Pecoflyer]

Hi

without seeing your data and the code, we can only take a guess...

[Simoninparis]

    
Worksheets("Agent").Cells(8, 2) = Feuil1.Cells(8, AgCol)
Maj(8, 2) = 8

Yes, part of the code is in French and part in English - this doesn't seem to affect the functionality.

"Feuil1" is the worksheet with all the data, The worksheet called agent is where I want the data to display. "Maj" is an array used to transfer up and down between the sheets.

Does this shed any light on the matter?