'Set as True to start. ColumnDoesNotHaveZero = True Count = ActiveSheet.UsedRange.Rows.Count 'loop thru column E and look for a zero. For i = 1 To Count Step 1 If ActiveSheet.Cells(i, 5).Value = 0 Then '5 is for column E ColumnDoesNotHaveZero = False 'it has a zero, set to False End If Next
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
22 Experts available now in Live!