>Hilmar,
>
>I asked some how to create a macro. I formatted a cell with a background color of RED. Here is what the code says:
>
> Range("A1").Select
> With Selection.Interior
> .ColorIndex = 3
> .Pattern = xlSolid
> .PatternColorIndex = xlAutomatic
> End With
>
>So I tried:
>
>.RANGE( "A1" ).Interior.ColorIndex = 3
>
>This worked. So I did the same for all the other colors I'll need.
>
>Thanks for the help.
>Mike
OK, great. As you can see, you can find out most commands by yourself this way. Some commands require constants that VFP doesn't understand - please read my article.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)