Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
1. Enters an Excel Code Module :-
For Each cell In ActiveSheet.Range("B6:N145") If cell.FormatConditions.Count 0 Then cell.Activate 'How could this statement be eliminated ? If Evaluate(cell.FormatConditions(1).Formula1) Then MsgBox "FormatConditions = True" End If End If Next cell 2. Would like to maintain the functionality of the above code after removing the statement, "cell.Activate". And so, that means that certain other replacement code must be emplaced thereof. 3. The primary objection to "cell.Activate" is that it causes screen- blinking and it's still blink-blink-blink of the screen despite that, Application.ScreenUpdating = False :cell.Activate is emplaced thereof. 4. Please share your experience. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula1-ferrari collection | Excel Worksheet Functions | |||
formula1-ferrari collection | Excel Discussion (Misc queries) | |||
FormatConditions VBA Bug? | Excel Programming | |||
FormatConditions(1).Formula1 | Excel Programming | |||
Bug in .FormatConditions.Add Type:=xlExpression, Formula1:=cfExpression | Excel Worksheet Functions |