Repeat macro

[wrightie]

Hi ,

I'm stuck. I'm not very good with macros/vba so any help or a nudge in the right direction will be much appreciated. I have the macro below which looks for the word "of" in column D when it finds it it clears the cell contents above and below it. This is my code -

Please Login or Register  to view this content.

What I would like it to do is carry on repeating itself until it gets to the last "of" in col D on the spreadsheet.

many thanks
wrightie

[snb]

Please Login or Register  to view this content.

[wrightie]

Hi snb,

Cheers for the quick response. I've tried the code but it seems to get stuck in a loop and the macro doesn't come to a finish.

Is there anything else I can try ?

wrightie

[romperstomper]

Try this:

Please Login or Register  to view this content.

[wrightie]

That's it romperstomper. Works perfectly, fantastic !

thanks for your help as well snb.

cheers
wrightie