>>>Hi all,
>>>
>>>I would like to change the color of certain cells when I create an Excel report. But can't find the right syntax. The following doesn't work. Could someone please tell me what will work.
>>>
>>>.RANGE( "A1").
BACKCOLOR = RGB(255,255,128)
>>>.RANGE( "A1").
.PATTERN.COLOR = RGB(255,255,128)
>>>
>>>TIA
>>>Mike
>>
>>If you save a macro in Excel, what commands are produced?
>
>Hi Hilmar,
>
>Excuse me? I have no idea how to use/create/save Excel macros. I can insert data to a cell/range. Change the border & font. Beyond that, I come here to ask for help.
>
>Mike
Then, I suggest you read my introductory article first:
http://www.levelextreme.com/Magazine/September2002/Page45.aspWith that, you can get the syntax of most Excel commands by yourself.
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)