Hi jp,
Color is the 10th argument of the Font.Properties statement
Full syntax:
FONT.PROPERTIES(font, font_style, size, strikethrough, superscript,
subscript, outline, shadow, underline, color, normal, background,
start_char, char_count)
Font.Properties(,,,,,,,,,ColorNumber0_56)
Regards
Frank
________________________________________________
Frank Arendt-Theilen, Microsoft MVP Excel
Am Thu, 2 Mar 2000 12:41:53 +0300, schrieb "jp"
"excel 4 help please":
Quote:
>What is the excel 4 macro function used to change text color?