>Hi Hilmar,
>
>This is what I get :
>
> With Selection.Interior
> .ColorIndex = 6
> .Pattern = xlSolid
> End With
>
OK. "Selection" should be changed to a Cell or Range object. For instance, if oSheet contains a reference to the current spreadsheet:
with oSheet.Cells(2,3).Interior
...
xlSolid is a constant that Excel understands, but VFP not. Please get download #
9498, extract it, and then put an #INCLUDE command into your program.
HTH, 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)
