Run time error 6 Overflow?

**ben5496** · 11-03-2011, 02:21 PM

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!

Please Login or Register  to view this content.

Any ideas?

**Leith Ross** · 11-03-2011, 02:34 PM

Hello ben5496,

A For Next loop requires a number for the control index. You have used RowIndex which you declared as Range not as a number.

**ben5496** · 11-03-2011, 03:06 PM

Hello

Thank you for your help, but I go the code the wrong way round. I defined it as long because some of the data sets are huge.
But still I have the run time issue

Please Login or Register  to view this content.

**Leith Ross** · 11-03-2011, 03:11 PM

Hello Ben,

Can you explain what you want the code to do?

**ben5496** · 11-03-2011, 04:05 PM

Hello the code uses three columns
Basically if column A1 and B1 are the same as A2 and B2 then it will add up the numbers in column C. but when consolidating the data it will come up with run time error 6

thank you for your interest and help

**Leith Ross** · 11-03-2011, 05:06 PM

Hello Ben,

Sorry for the delay, I was out for awhile. If can post your workbook then I can do this faster.

**ben5496** · 11-06-2011, 05:37 AM

Hello
SORRY for the delay
here is my work book, just to refresh the error comes out run time error 6 'overflow'.
Thank you for help

I do not have the data but, it is consolidated into three columns. A B C. The the data is consolidated by matching column A1 and B1 to A2 and B2 and so on until it has reached the end of the list. when A1 and B1 are match to A2 and B2 the figures in column C1 is added to column C2