Dynamic Range and clearing contents

[Marvalisa]

How do you clear the contents automatically with a dynamic range? More specifically, how to you clear the content when your range changes from 20 to 10 data values. In other words you make the range size smaller. I can clear formatting but not content automatically?

 

[ParamRay]

.
.

The Range.ClearContents method works with ranges of any size. For example, you can use something like:

Worksheets("Sheet1").Range("A1:G37").ClearContents

 

[Marvalisa]

Thank you for your reply. I am not trying to clear the entire worksheet. I want to clear a particular column at a certain point which corresponds to a dynamic range that changes.
Maybe I should just create a macro.