workbooks("nonexistentworkbookname.xls")

would give you a subscript out of range error. So using a non existent
index into a collection would be a prime cause for this type of error.

--
Regards,
Tom Ogilvy

"Lacys" wrote in message
...
Could anyone tell me what "subscript out of range" means.
It's comming up where I have

Total=0
then a for loop to figure new total. Could someone please
help.

Thanks,
Lacy