Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code looping until machine freezes!!?
Hi all, I have tried to devise some code so that if a cell in a set rang contains a value or character of any kind to change to a colour, i works but seems to loop many times until my machine freezes (i ca press escape to get out of it!) any ideas why and perhaps a nudge i the right direction please! Thanks, Simon. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim mycell Dim rng As Range Set rng = Range("V2:V40") For Each mycell In rng If mycell < "" Then mycell.Select With Selection.Interior .ColorIndex = 44 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End If Next End Su -- Simon Lloy ----------------------------------------------------------------------- Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670 View this thread: http://www.excelforum.com/showthread.php?threadid=47607 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel xls files open as Machine Code | New Users to Excel | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Macro code error; machine dependent | Excel Worksheet Functions | |||
Line of code hanging up on one machine??? | Excel Programming | |||
code is not working on another machine | Excel Programming |