| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Font color setting problem
I am trying to set the color of a range of cells based on the number of a looping variable (Count). The following code gives me an error indicating that the color can't be set using a variable name. What would be an alternate way to do this? For Count = 1 To 60 Sheets("Sheet3").Select Range("B5").Select Selection.Font.ColorIndex = Count Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with setting Interior Color in VBA | Excel Programming | |||
| Problem with setting Interior Color in VBA | Excel Programming | |||
| Problem setting font size | Excel Programming | |||
| Problem in setting Cell Interior Color filling. | Excel Programming | |||
| vba: setting font color to entire sheet | Excel Programming | |||
Threaded Mode
