Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell.interior.colorindex - does not work in Excel 97
I have the following code in an excel 2000 spreadsheet:
Private Sub CommandButton1_Click() For Each cell In Range("c5:H32") cell.Interior.ColorIndex = 0 Next cell End Sub But it does not work in Excel 97. Any ideas why? I get run time error 1004 Ian, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding last occurence of Interior.ColorIndex 36 | New Users to Excel | |||
Sumif interior.colorindex condition | Excel Worksheet Functions | |||
interior.colorindex used with conditional formatting | Excel Worksheet Functions | |||
VBA syntax for Font & Interior ColorIndex | Excel Discussion (Misc queries) | |||
Testing for Interior.ColorIndex | Excel Programming |