Hello, I have this program that im trying to fix, the problem is it comes up with run time error 6 overflow, it states the problem is with the below. But when i delete the data and try it again it will work without the error, very werid!
Dim RowIndex As Range, Col1Cell As Long
For RowIndex = Cells(Rows.Count, Col1).End(xlUp).Row To StartRow + 1 Step -1
For Each Col1Cell In Range(Cells(StartRow, Col1), Cells(RowIndex - 1, Col1))
If Col1Cell.Value = Cells(RowIndex, Col1).Value _
And Cells(Col1Cell.Row, Col2).Value = Cells(RowIndex, Col2).Value Then
Cells(Col1Cell.Row, Col3).Value = Cells(Col1Cell.Row, Col3).Value + Cells(RowIndex, Col3).Value
Cells(RowIndex, "A").EntireRow.delete xlShiftUp
Exit For
End If
Next Col1Cell
Next RowIndex
Any ideas?
Bookmarks