Excel and VB 6.0

sextdav

New Member
Joined
Sep 10, 2002
Messages
2
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
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
Please copy and paste your code here. We need to see your code!
 

sextdav

New Member
Joined
Sep 10, 2002
Messages
2
Thanks for the interest in helping me, but I managed to figure it out myself. Thanks anyway.

DES
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,455
Members
412,595
Latest member
slim313
Top