excel issue 1

[wuwang]

Hello,

I had code to have the color of some cells as yellow. Now I want to clean up the whole worksheet cells color back to white. The ClearContents not for this issue.

Which function I should use?

Thanks

 

[csjoseph]

Sheet1.Range("a1:a5&quot.Interior.Color = vbWhite Chris
LAN Admin / Programmer
cjoseph@hdii.com

 

[wuwang]

Thanks Chris.
I put the code like this

Workbooks("xxx.xls&quot.Worksheets(1).Interior.Color = vbWhite

But I recieved a error said "Object doesn't support this property or method.

Mine is in EXCEL 97.

 

[csjoseph]

Where are you running the code? VBA in that Excel sheet or from an external app? Chris
LAN Admin / Programmer
cjoseph@hdii.com

 

[wuwang]

I careated a form in EXCEL. I want to put the code
in the form. This code will cleanup the background color
in the worksheet once the form initialized.

 

[csjoseph]

Try like this.

Sheet1.Cells.Interior.Color = vbWhite

Substitute SHeet1 for what ever sheet it is on. Chris
LAN Admin / Programmer
cjoseph@hdii.com

 

[SkipVought]

Hi,
Actually, what you probably THINK is white, is PROBABLY xlNone.

ActiveSheet.Cells.Interior.ColorIndex = xlNone

Skip,
metzgsk@voughtaircraft.com