ClearContents problem (SOLVED)

[phantom1975]

I have this simple macro:

Sheets("Sheet1").Range("A3:A1000").ClearContents

When I try to run this macro, I get this error message:

Run-time error '1004':

ClearContents method of Range class failed

These are not protected cells, so I have NO idea what the issue is. Any ideas?

_________________
Pass on what you have learned. Support this great website by clicking on the sponsor's ads!.
This message was edited by phantom1975 on 2002-10-11 00:32

 

[Spicymeatballs]

I had the same problem: deleting several columns didn't work. I solved it by deleting first the column with formulas inside. If you have a "helper column" filled with formulas this might cause excel to overload, especially if you have 10k+ rows.