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" <titushanke.1wsr2g_1129133134.1155@excelforum-nospam.com> wrote in message
news:titushanke.1wsr2g_1129133134.1155@excelforum-nospam.com...
>
> 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
>