Range object failed - random error

[Lenny]

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