Application-defined or object-defined error

[Bishop]

I have the following code:

Worksheets("Fail Stats").Cells(FSStartRow, "A") = Cells(i - 5, "A").Value

I keep getting Application-defined or object-defined error. I also tried:

Worksheets("Fail Stats").Cells(FSStartRow, "A") =
Worksheets(center(i)).Cells(i - 5, "A").Value

But that didn't work either. What am I doing wrong?

 

[Jacob Skaria]

Check out the value of i . If i-5 is less than 1 it will return error

If this post helps click Yes

 

[Bishop]

That was it! I was using the wrong variable... should have been j instead of
i.

Thanks