Hi everyone,
would you like to help me??

In sheet 1, I must find the word "POPULATION",after that I must clear content all row below until row 99 because in row 100 the word "AVERAGE" is not allowed to be cleared/deleted. How to make clear content process stop automatically when it reach row 99. How to make by DO WHILE LOOP, FOR NEXT or any other solutions because I am a beginner in VBA.

And so on until sheet 10
Thank your for your suggestion