1st time post - long time reader
when i put in the code
Worksheets("Name of Sheet").Range("m5:m500").ClearContents
It takes forever to run.
Is there a simpler/faster way to code what i want? Ive tried .clear and .delete with no progress.
Thanx for the replies
BTW - this happens in excel 97 and above