December 03, 2020, 07:27:28 am
News: IF YOU ARE A MEMBER FROM THE ORIGINAL SITE AND CAN'T LOGIN. POST IN THE FEEDBACK FORUM (AS GUEST) AND AN ADMIN WILL ASSIST YOU TO ACCESS THE SITE!
Pages: [1]   Go Down
Author Topic: Lost Topic Title  (Read 522 times)
maxl
Sr. Member
*

Stars: +0/-0
Offline Offline

Posts: 483



WWW
« on: July 18, 2003, 08:39:38 pm »

Hi, I have a program that creates an excel Worksheet and I can't find a property to change the backcolor of cells. Can you do that ??
« Last Edit: July 21, 2003, 12:53:29 pm by maxl » Logged

Thanks for helping !! If I helped then you better thank me Another Tounge


Pc_Madness
Ancient Poster
*

Stars: +0/-0
Offline Offline

Posts: 5349



WWW
« Reply #1 on: July 19, 2003, 01:26:20 am »

Code:
Excel.Range("CellColCellRow").Select
    With Selection.Interior
        .ColorIndex = 46
        .Pattern = xlSolid
    End With

CellColCellRow = G7 or something like that. Another Tounge
« Last Edit: July 19, 2003, 01:28:28 am by Pc_Madness » Logged


maxl
Sr. Member
*

Stars: +0/-0
Offline Offline

Posts: 483



WWW
« Reply #2 on: July 21, 2003, 12:53:14 pm »

Thanks
Logged

Thanks for helping !! If I helped then you better thank me Another Tounge


Pages: [1]   Go Up
Print
 
Jump to: