Posted to microsoft.public.excel.programming

frankt

external usenet poster

Posts: 4

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a COMMAND to stop a current process in Excel(Copy/Delete/	Stegra	Excel Discussion (Misc queries)	1	January 13th 09 02:52 PM
"ClearContents" command halts code	Dave O	Excel Discussion (Misc queries)	3	January 10th 08 03:39 PM
Clearcontents	Caroline Vincent	Excel Programming	2	September 9th 04 11:03 AM
Clearcontents	Dick Kusleika[_3_]	Excel Programming	0	February 17th 04 05:42 PM
IF Command to Stop Macro	ianripping[_23_]	Excel Programming	4	January 16th 04 04:35 PM

All times are GMT +1. The time now is 05:38 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us