I have a macro that works fine. I wish to run it on 12 worksheets one after the other but only if cell A2 of the active worksheet has data in otherwise go to next worksheet in the range and run the macro. In other words go to the first sheet in the array of sheets, test cell A2 and if blank skip to next sheet. If A2 has value run the macro then go to next sheet and so on until all 12 sheets have been processed. The reason is the macro crashes if it hits an empty sheet and cell A2 is always going to have a value if the sheet has data. There are other sheets in the workbook so I need to be able to specify the array of sheets somehow. Any help will be gratefully accepted.