Define:Run-time error '1004'

**Johnyue** · 01-02-2007, 07:27 PM

When I run my code every thing works ok, but it got error when the row number went up to 257 at the second red line. The error message is Run-time error '1004' Application-defined or object-defined error. I have value in cell A257 just like any other A cells. Nothing really funcy.

rw(1) = 512
rw(2) = 408
Worksheets(wSheet(1)) = "template1'
Worksheets(wSheet(2)) = "template2"

Any one can help me on this?
Thanks a million.

John

Here is the code:

Please Login or Register  to view this content.

**Maistrye** · 01-02-2007, 07:55 PM

Was looking through this... and I don't understand some of the code you have posted.

You have a 'next cll' without a preceding 'for cll = ...' (That may be possible, but seems rather strange)

You also seem to have variables coming out of nowhere (ie. jjj) that do not seem to be initialized, and it's hard to make a determination without knowing what values they contain.

Also, iil gets initialized to 1 every time through the loop and then incremented to 2. If it itself is part of a loop, it's a different story, but the logic seems off.

You're going to have to clarify some of these issues, unless someone sees something else that might be triggering the problem.

Scott

**Johnyue** · 01-02-2007, 08:44 PM

Hi Scott,
I posted my full code now. Sorry for the comfusion.

Thanks a million.

John

**Maistrye** · 01-03-2007, 12:00 AM

I was staring at your code for a few minutes... then I realized your actual mistake was in the original bit you posted. I was just distracted by the other things that seemed odd.

You've reversed the parameters to Cell(). "With Worksheets(wSheet(2)).Cells(1, j)" when j = 257 doesn't address A257, it addresses IW1.... which unfortunately doesn't exist. :-)

That is, it's "Row, Column", not "Column, Row".

Scott