I need to display a message box when all the values in a range on my spreadsheet are zero. Currently I am using the following code:
Dim Cell As Range For Each Cell In Range("E17:E25") If Cell.Value = "0" Then MsgBox ("If hardware is required, please manually populate the corresponding sections.") End If Next
The message is displayed, however it is shown 9 times (for each of the cells in the range). What I need is to check if all the values in the range
E17:E25 are zero, and then display only one message box. Any ideas?