Runtime Error '9' - Subscript Out of Range

Giganews Newsgroups
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
YELLOW)
        For j = 1 To 4
            Worksheets(Sheets(j).Name).Activate
            Rows(CopyValue).Copy
            Rows(RNValue).Select
            Selection.Insert Shift:=xlDown
        Next j
    Next i

Any ideas what cause might be?  We all have same version of
Excel....and same version of VB.

Replies