In the following code I have run this and there was 4 rows and the count was 14? The previous test was 14, but the current test was 4... How can I reset the "Count" so it reads accurate each time and does not keep what the previous count was. Please advise and thanks.
'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