Clear Contents in Specific Rows via condition

Hi All,

I am fairly new to Excel VBA coding. I have some programming background, but not enough to get through this task. I am sure its not that hard, but with my current code, I am stuck in a for loop.

So here is my question:

I have a workbook with about 30 worksheets and in each worksheet in column R there is data, either some text or the number "0". If there is a number "0" I need to clear the content from cells F3 to Q50. The content needs to be cleared for the range given for each each worksheet within the workbook. Can someone help me out with this VBA code?

Thanks~ :)

Please read the Forum Rules & use appropriate wording for your Thread Titles.

It might help to post your existing code.

Can the 0 be in any cell withi Column R?

Hi RoyUk,

Thank you for your reply and advice. I have changed the topic of my question. Hopefully this will help.

The "0" will be in column R within the range of R3 to R50. It is at random, some of these cells will contain text and some of them will contain "0". All the cells that contain "0", I need to clear the content in the same cells row within the range of F3 to Q50.

Example if Cell R5 contains a "0" I will need to clear the content in the cells range F5:Q5.

I hope this makes sense~

Thanks!

Thanks for co-operating. Do you want to empty those cells or delete the Row?

Maybe

Please Login or Register  to view this content.

VBA Noob

Try this
Edit: amended the code

Please Login or Register  to view this content.

royUK,

The reason Excel Newbie05 didn't respond was he cross posted it on JMT.

Excel Newbie05,

Please read forum rules and message to cross posters below and then add the link to the cross post

VBA Noob