ExcelBanter - ClearContents command causes routine to stop

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - ClearContents command causes routine to stop (https://www.excelbanter.com/excel-programming/327240-clearcontents-command-causes-routine-stop.html)

Peter Ekstrom

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

frankt

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

All times are GMT +1. The time now is 11:39 PM.