Overflow Error 6 Excel VBA

Question

I'm using a counter to keep track of true/false conditions in a range, with the value of that counter used to determine further action. However, I'm getting an overflow error even when a small (15 row) data set is being read. Here's the code:

Dim b As Double     'Exceptions Sheet
Dim u As Integer    'Unhandled exception counter

b = 2

Sheets("Exceptions").Activate

Do While Sheets("Exceptions").Cells(b, 2).Value <> ""
    If Sheets("Exceptions").Cells(b, 14).Value <> "A" Then
        u = u + 1
    End If
Loop
    b = b + 1

~Thanks~

Tim Williams · Accepted Answer · 2016-08-05 19:55:39Z

2

You're not changing the value of b in the loop, so it just keeps incrementing u until it overflows

answered Aug 5, 2016 at 19:55

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Overflow Error 6 Excel VBA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related