Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range object failed - random error
Hello,
I am using Excel automation in VB6. My program creates excel reports 40 - 50 files depending on criteria. Some files might have 10 - 20 worksheets. I am getting an error "method Range _object failed" A strange thing about it happens randomly. The program will run with no problems couple of times, but then after creating more files this error occurs. Again it's totally random, it happens creating different files, different worksheets. Any ides? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range of Object _Global Failed | Charts and Charting in Excel | |||
Charts.Add error '1004' Method 'Add' of object 'Sheets' failed | Charts and Charting in Excel | |||
Intermittent Error - Method 'Add' of object 'HPageBreaks' failed | Excel Worksheet Functions | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) |