Help! runtime error '1004' working with "Range"

secure · January 29th, 2010, 05:47 AM

Hi every1,
I'm new to this forum, sorry to start with a question.
I'm having problem with an excel vba code as follows:

Code:

Dim IndexBSC, IndexBTS As Double, IndexBB As Range
For i = 2 To ix Step 6
Set IndexBB = Sheets("BSC KPI").Range(Cells(i, 6), Cells(i + 5, 6))
    IndexBSC = WorksheetFunction.Match(WorksheetFunction.Max(Sheets("BSC KPI").Range(Cells(i, 6), Cells(i + 5, 6))), IndexBB, 0)
    Cells(i, 12).Value = Sheets("BTS KPI").Cells((i - 2) + IndexBSC + 1, 9)
Next i

when I run the code, a runtime error saying "application-defined or object-defined error" appears for the yellow line.

I appreciate if any1 can help.

Thanks in advance