Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I have a macro that I use to replace all "NULL" 's with "". On a small amount of data, everything works fine. But currently I'm working on an amount of data about 45,000 rows x 92 columns. I usually let it run for 10 seconds and then do a [Ctrl] + [Pause/Break], otherwise it gets bogged down and then I get "Out of memory" errors and message boxes. The problem is when I do these [Ctrl] + [Pause/Break]'s, I get just the generic "Code execution has been interrupted. Continue? End? Debug? Help?" message box. I would like to replace that generic message box with my own custom one that will show my progress through the selected range. Can this be done with On Error Goto? Can I check for the [Ctrl] + [Pause/Break] key combo another way? Thanks for any help anyone can provide, Conan Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Diable Ctrl+Break | Excel Programming | |||
CTRL +BREAK | Excel Programming | |||
Ctrl+Alt+Break | Excel Programming | |||
Can Not Get Macro to Break with CTRL-BREAK | Excel Programming | |||
How to disable the Ctrl+Break ? | Excel Programming |