Clear Contents of Repeating Column Ranges

Hello I have a sheet with experimental data that I want to be able to clear so I can retest the formulas and codes.

The ranges are :

C5:F400
H5:K400
M5:P400

and across to including all groups

DS5:DV400

These skip a column and I was wondering if there can be a code that I can select to run to clear these cells of content.

I appreciate any help or suggestions,
Billy

How about

Please Login or Register  to view this content.

That works great thanks. One other question if possible. I assigned it to a shape to click and run it. Can I have it password protected?

If you mean stop other people from using the macro, try

Please Login or Register  to view this content.

Where the value in red is the password

great that is perfect!

Glad to help & thanks for the feedback

Hello again,

I know this one is solved but I have another sheet to clear.

The ranges are different though.

G5:I400
P5:R400

HO5:HQ400

Can this be done also with a similar password protected code?

Thank you,
Billy

Copy the nacro & change the last part to

Please Login or Register  to view this content.

Brilliant!

I am trying to figure out the numbers. Can you explain how it works?

It's basically working on columns, so
7 is col G
225 is col HQ
Step 9 means i goes from 7 to 16 to 25 etc which is then Cols G,P,Y etc
so we start with cells(5,i) which is G5, then resize(396,3) means to resize by 396 rows making G5:G400 & by 3 columns making it G5:I400
i then becomes 16 so we have P5 which is resized to P5:R400

HTH

That does help thank you very much. This is quite handy and I will put it to good use.

Glad to help