Runtime Error '6' Overflow error at row 32767

[leeloo0505]

Hello,

I am running a macro that retrieves data from a DB. The entire table is only 35,045 rows. I am trying to retrieve all the rows from the table but for some reason when it hits row 32,768 rows it says 'Runtime Error 6: Overflow. All previous 32,767 rows are brought into the sheet fine.

The sheet I am writing too is 'cleared' before the import.. anyone have any suggestions?

leeloo

 

[Mark O'Brien]

Change your "Integer" declaration to "Long".

Is that a good guess without seeing any code?

 

[leeloo0505]

Awesome! Yep that was it, had my irow2 defined as a integer...
thank you so much!

leeloo

 

[Mark O'Brien]

Sweet.

 

[treckor]

I did that but now I get ByRef argument type mismatch

 

[shg]

On what?