Excel and VB 6.0

[sextdav]

I've written an app to add rows of information to an excel file. Everything works fine until the row number exceeds 460.
Then I get the following error :

run time error '1004':
application-defined or object-defined error

Does anyone know why it does this, or a way around it??? Any help would be greatly appreciated.

Thanks

DES

 

[Joe Was]

Please copy and paste your code here. We need to see your code!

 

[Legacy 98055]

Hi DES
Post your code.
TOm

 

[sextdav]

Thanks for the interest in helping me, but I managed to figure it out myself. Thanks anyway.

DES