Code to clear multiple contents

[ABSTRAKTUS]

Hi all,

I have a spreadsheet that is updated every morning. To do that user needs to delete the old data within ranges. The trouble is that there are ~150 contents to clear. Is there a code that clears multiple selections?

Thanks in advance guys!

[tigeravatar]

ABSTRAKTUS,

As an example, if you needed to clear A2:B3, D5:E6, and F8:H12, you could use:

Please Login or Register  to view this content.

[ABSTRAKTUS]

Was it that easy??? Thanks mate! Do you know how many ranges XL 2003 would accept or is it unlimited?

[tigeravatar]

I know there is a max, but don't know what the max is, sorry