working whit excel

[saeed rezaei]

hi
i am saeed rezaei (e-mail address removed)

who is knowh how i can changing the excel cells backcolor.

now i can working whit excel but still i cant change the backcolor of cells.

 

[Herfried K. Wagner [MVP]]

who is knowh how i can changing the excel cells backcolor.

now i can working whit excel but still i cant change the
backcolor of cells.

Give the Excel programmers a try:

<URL:

 

[Guest]

Try the following out:
xlRG = xlWS.Cells(row, 7)
xlRG.Font.Bold = True
xlRG.Font.Color = 255 ' sets font color to RED
xlRG.Interior.ColorIndex = 34 ' light blue
xlRG.Interior.Pattern = Excel.XlPattern.xlPatternSolid

where xlRG is a range object and xlws is the worksheet object