Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can you make this faster?
here is the code... is there a quicker way to do this?
Private Sub Worksheet_Calculate() Dim Target As Range For Each Target In Range("p4:p34") If Target.Value = True Then Cells(Target.Row, "G").Resize(1, 24).Interior.ColorIndex = 15 End If If Target.Value = False Then Cells(Target.Row, "G").Resize(1, 24).Interior.ColorIndex = xlNone End If Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Excel Work faster | New Users to Excel | |||
How Can I make excel go faster | Excel Programming | |||
make my vba/excel program faster | Excel Programming | |||
make my vba/excel program faster | Excel Programming | |||
make my VBA program faster | Excel Programming |