Clear column C from 2 to 10 000 if (Excel 2003)

[Excelnoub]

I am having trouble modifying the following information code:

Please Login or Register  to view this content.

The code adds the information on an extra line if you add a number in Column C. I need it to clear the info after it has run the VB code from Column C2 to C10000.


So instead of

Please Login or Register  to view this content.

It would be ???

Please Login or Register  to view this content.

Thank you for your time

[patel45]

Range("C2:C10000").ClearContents

[Excelnoub]

Giving me a run time error

[patel45]

excel 2003 limits:
max rows 65.536
max columns 256

[Excelnoub]

It adds the function but it will not clear afterwards.

Runtime error "1004"

I added the code right after the last "End With"

[patel45]

excel 2003 limits:
max rows 65.536
max columns 256

[Excelnoub]

It's the rows I want to delete but in Column C

So everything between C2 and C10000 I want it to clear after the code has run.

Ex: if I add in Column C2 = 002 it will add a row, then offset the info then I need it to clear all of column C starting at row 2.

[StephenR]

Just a typo. Replace the ; with a : in patel45's code.

[patel45]

Thanks StephenR, I updated

[Excelnoub]

You guys are life savers, works like a charm.