| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evaluate cell in range and change cell attribute
I've been working on the following code, but get an error on the
designated line - can someone help? Dim rCell As Range Sheets("Form").Select Range("B2:C450").Select For Each rCell In Selection.Cells If rCell.Interior.ColorIndex = 35 And rCell.Value = "" Then <--- ERROR OCCURS rCell.Borders.Color = 3 End If Next rCell |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Caption attribute at Cell in Excel XML | Excel Discussion (Misc queries) | |||
| Evaluate Range of Cell | Excel Programming | |||
| How to write vba to evaluate the text font and size on an active cell range? | Excel Programming | |||
| Push value to a cell attribute? | Excel Programming | |||
| Change cell colour for a cell or range within a predefined range | Excel Programming | |||
Threaded Mode
