>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement