Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Colours
Hi
I am trying to write a short piece of code that loops through a number of cells in a given row and increments a counter depending on what colour the interior of the cell is. I am using the following code For vC = 10 To 100 With Worksheets("Closed Issues").Cells(vC, 6) Select Case (.Selection.Interior.ColorIndex) Case 6 'Yellow vYellow = vYellow + 1 Case 1 'Red vRed = vRed + 1 End Select End With Next but keep getting error 438 'Object doe not support this method or property'. Can anyone see a reason why this is happening or suggest a solution? Thanks TJ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Colours in Excel | New Users to Excel | |||
Counting Cells with specific Colours | Excel Discussion (Misc queries) | |||
Counting cell colours | Excel Worksheet Functions | |||
Counting colours | Excel Worksheet Functions | |||
Counting colours | Excel Discussion (Misc queries) |