hi,
I am looking to clear the contents of E120:F152 and H120:K152 if the contents of cell G117 is automatically populated by the word "stop" The spreadsheet is connected to software that does this ( I believe this to be a worksheet Change event) I am a beginner with vba and don't know how else to tell it .
I need this to apply to 60 seperate sheets.
There are 3 other sheets in the workbook that it should not apply to
Thanks for any help
Paul