| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ClearContents command causes routine to stop
In Excel 2003 the following command causes execution to stop.
ActiveSheet.Range("C17:T20000").ClearContents It works fine in Excel 2000 though... Any ideas??? Peter |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ClearContents command causes routine to stop
You could be getting a warning message that is not appearing in the current
Window. Try adding Application.DisplayAlerts = False before that step. "Peter Ekstrom" wrote: In Excel 2003 the following command causes execution to stop. ActiveSheet.Range("C17:T20000").ClearContents It works fine in Excel 2000 though... Any ideas??? Peter |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a COMMAND to stop a current process in Excel(Copy/Delete/ | Excel Discussion (Misc queries) | |||
| "ClearContents" command halts code | Excel Discussion (Misc queries) | |||
| Clearcontents | Excel Programming | |||
| Clearcontents | Excel Programming | |||
| IF Command to Stop Macro | Excel Programming | |||
Linear Mode
