Clear Contents of range, offset and repeat

I'm having some trouble with a macro, hoping the gurus can help.

I have a spreadsheet that has data in cells B8:F27 for a specific person. At the beginning of the year, this data needs to be wiped.

The next person's data is in cells I8:M27 (same size and shape). And so on...

I'm trying to write a macro to clear the contents of range B8:F27, skip to I8:M27, clear the contents, and continue doing so until there is no data.

Here's my code so far:

Please Login or Register  to view this content.

Any guidance would be greatly appreciated.

Perfect! Thanks Norie!

Remind me how to show this thread "resolved"?

Thanks Again!