Good afternoon,

I'm very much new to vba, even though I have some knowledge of excel.

What I'm looking for is some code that evaluates cells AP9,11,13,15,17,19 and if they have a value of 1 (derived from a formula), to clear the contents of the corresponding cells in O9,11,13,15,17,19. This needs to be applied to an entire workbook with multiple sheets.

I'm looking to learn more about vba, but I'm completely stuck on this at the moment, so any help would be much appreciated.

Cheers all,

George