Deleting rows on reverse order using For Next loop

[Roshan.Shakya]

Hi experts and gurus,

I have got the data which I want to delete on reverse order using For / Next Loop. The sample data are as under:

January
February
March
April
May
June
July
August
September
October
November
December
January
February
March
April

The delete operation should stop once it reaches to "December". I wrote the following code, which keeps on deleting even after it finds the word "December".

Please Login or Register  to view this content.

I appreciate any guidance to stop the operation when the loop finds the text "December". Also I would welcome suggestion on finding "December" and then deleting all the rows thereafter.

Thank you
Roshan Shakya

[BanginMyHeadOnMyDesk]

Maybe this?

Please Login or Register  to view this content.

Beth.

[mohadin]

Hi you may

Please Login or Register  to view this content.

[Roshan.Shakya]

Both of you were excellent.

I appreciate your codes.

Thank you
Roshan Shakya

[mohadin]

you are well come
Be happy

[jolivanes]

You are happy with the suggestions but I would change this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

just in case you will be close to the last row (very unlikely) of the sheet.

Or you could use a single line like this

Please Login or Register  to view this content.

[Roshan.Shakya]

Thanks jolivanes for the code.

Roshan Shakya