|Subject:||Runtime Error '9' - Subscript Out of Range|
|Posted by:||Ben (bdicarl…@yahoo.com)|
|Date:||Mon, 21 Jul 2008|
We have 5 spreadsheet which reside on a network drive. The
spreadsheets are macro driven, and we have issue that only the person
who setup the macro's is able to run them. For everyone else, we
receive Runtime Error '9'. We have tried copying to local drive, and
same issue. Only the creater of the macro's can run them, and this
person is leaving the company. They are unable to figure this out.
When I receive error and click Debug...it goes to following location
in the macro:
For i = 0 To NumOfLeads 'adjust TL's sheets
Windows(PageName(i)).Activate (THIS LINE IS HIGHLIGHTED
For j = 1 To 4
Any ideas what cause might be? We all have same version of
Excel....and same version of VB.