kingbob
02-05-2014, 03:59 PM
Hi Friendly People of vbaexpress,
Can someone tell me how the following would be possible.
I have a Workbook with a LOT of worksheets in it.
Each work sheet has a value (Lets say the value is 1), In Cell A1.
I want to write a formula that checks every single worksheet to confirm that A1 in each worksheet has the value 1.
If a worksheet does not contain the value 1 in cell A1, is there a way I can have excel tell me exactly WHAT worksheet has the error? (So that i then dont have to go painfully looking at each individual worksheet).
Can someone tell me how the following would be possible.
I have a Workbook with a LOT of worksheets in it.
Each work sheet has a value (Lets say the value is 1), In Cell A1.
I want to write a formula that checks every single worksheet to confirm that A1 in each worksheet has the value 1.
If a worksheet does not contain the value 1 in cell A1, is there a way I can have excel tell me exactly WHAT worksheet has the error? (So that i then dont have to go painfully looking at each individual worksheet).