Hi Titus,
Try turning off calculation and screen refresh:
http://www.mvps.org/dmcritchie/excel...htm#slowmacros
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"titushanke" wrote in message
...

Dear all,

I am using the macro as defined earlier:


Code:
--------------------
Sub ColorNoFormulasAllCells()
Cells.Interior.ColorIndex = xlNone 'Optional, to reset shading
On Error GoTo AllFormulas
With Cells.SpecialCells(xlCellTypeConstants, 23).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With
AllFormulas:
End Sub
--------------------


The problem I have is that when I do an operation in many cells (like
"search and replace"), the screen blinks millions of times as the macro
is working through all cells for every replace check...

Is there any solution to avoid this as this is taking loads of time? I
remember there was some operation to have macros run without screen
refresh, but I couldn't find it again here in the forum....

Thanks to all reading this,

Titus.


--
titushanke
------------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...o&userid=19997
View this thread: http://www.excelforum.com/showthread...hreadid=469193